Forums

Mysql question (8 posts)

  1. knotty
    Member
    Posted 4 years ago #

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

    Thanks!

  2. moshu
    Member
    Posted 4 years ago #

    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".)

  3. knotty
    Member
    Posted 4 years ago #

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

  4. moshu
    Member
    Posted 4 years ago #

    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.

  5. Viper007Bond
    Member
    Posted 4 years ago #

    If you have phpMyAdmin, browse around and you'll quickly realize how differently formatted the database structures are. ;)

  6. knotty
    Member
    Posted 4 years ago #

    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!

  7. skippy
    Member
    Posted 4 years ago #

    A SQL backup should be a plain text file.

  8. Viper007Bond
    Member
    Posted 4 years ago #

    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?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags