phpMyAdmin export – Copying DB tables goes wrong

  • Kjetil

    (@kjetilgf)


    17 years ago

    Hi
    I need to know how I can copy some tables from one database to another – and make the contents appear there. Also: How to avoid character problems.

    Problem is: I’ve been using the rs-discuss plugin to run a forum and now need to copy the tables into another database (inside the same domain). I’ve use phpMyAdmin to export the three rs-discuss tables (wp_rs_discuss_forums/ ..posts/ ..topics – all names should contain rs_discuss, right?) After importing them to the other database, I set up a rs-discuss-based forum to ensure everythig’s OK – but no.
    – The forums show up and the rs-discuss’ post counter in the three forum look OK – but only one forum is possible to open, and there only one post opens (the oldest)
    Also – foreign characters (?/?/?) becomes a mess.

    Anyone who knows in detail the settings I should use for the tables’ export? Or is something else crucial here?

    Really grateful for any suggestions,
    Kjetil

    phpMyAdmin export settings
    After choosing the 3 tables that appears to contain all rs-discuss stuff, I’ve chosen:

      Export: SQL

    • Options – Structure: Add Drop table + Add Auto increments + Enclose table and field names with backquotes + export compatibility: None
    • Options – Data: Use hexadecimal for binary fields
    • Export type: Insert

    …and then saved it as a file that I then uploaded using the SQL tab in phpmyadmin – with character set to default utf8.
    Any obvious mistakes?

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    Alex King’s blog might help you:
    https://alexking.org/blog/2008/03/06/mysql-latin1-utf8-conversion

    Thread Starter Kjetil

    (@kjetilgf)

    Thanks Michael,
    I’ll give it a try – though I’ve had to ask Alex&co for some details that might get the characters correct

    BUT – the main problem is still to gain access to the forum posts. I still believe I’ve done something wrong when exporting the tables.
    Maybe I’ve even exported them in the wrong format (sql, csv, xml) or somehow have to manipulate the exported file before importing it.
    Or do you believe the character part could cause also the access problems?

    Kjetil

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘phpMyAdmin export – Copying DB tables goes wrong’ is closed to new replies.