WordPress.org

Support

Support » How-To and Troubleshooting » Mysql question

Mysql question

  • Can you take a mysql db file created in say B2 or Nucleus, and restore it into a empty WP db?

    Thanks!

Viewing 7 replies - 1 through 7 (of 7 total)
  • I guess you can. Which doesn’t mean it will work 🙂
    (I mean you can put anything in the db, but if it’s not related to WP, the script and the DB won’t “communicate”.)

    But what makes it related to a particular program? the filenames? is the difference too great to be practical?

    Differences: the table names, how the data is organized in the tables, columns, etc. Usually all the scripts that use DB create their own tables with a specific goal in mind and if the data is not organzied in the same way it is totally useless for another script.

    If you have phpMyAdmin, browse around and you’ll quickly realize how differently formatted the database structures are. 😉

    Ok, thanks, just what I wanted to know. Best to stay same program.

    By the way, do you know of a program what will convert the sql file to a formatted plain text file?

    Thanks!

    A SQL backup should be a plain text file.

    An .sql file is a text file, it just has a different file extension. Open it with your text editor.

    Best to stay same program.

    You know WordPress comes with a bunch of importers for converting the structure of your old data to WordPress’ structure, right?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Mysql question’ is closed to new replies.
Skip to toolbar