Easy way to import MySQL dump

  • cgonyea

    20 years ago

    I had to do a very quick and not planned transition to a new web hosting company after the previous company decided to go belly up. I got off all my data from the old server.
    I have a MySQL dump (in a text file) that contains all of my blogs comments and posts. I would like to import these onto my new server, but for reasons I can’t figure out I was unable to create the same database name that I used on my old server. Thus, I don’t know how to import these entries now like the document on the WordPress Wiki suggests I do.
    Can anyone help me figure this out? My experience with MySQL is limited at best to none at all.

Viewing 6 replies - 1 through 6 (of 6 total)
  • prara

    (@prara)

    You can use phpMyAdmin to ease up your mysql administration.

    Thread Starter Anonymous

    I know that I can use phpMyAdmin. The question is how do I import these entries if the new database name is different from the old database name?

    moshu

    (@moshu)

    But you still will have the same table names (prefix), so having a different db name is only a matter of changing it in the config file, isn’t it?

    The database name shouldn’t actually matter.
    I just checked my last backup, and although the db name is there, it is commented out, with just the table names being what matters.
    You should be fine just restoring the db.

    Thread Starter Anonymous

    Ok, here goes nothing. Thanks for the help, I’ll see what happens.

    Thread Starter Anonymous

    Ok I did it, I got everything imported. However, I had a horrible time doing it and have written a rant about the export/import process.
    WordPress developers, I highly suggest you read my post on the subject:
    https://www.chrisgonyea.com/blog/archives/2004/11/07/notes-switching-hosts/

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Easy way to import MySQL dump’ is closed to new replies.