3 Votes Vote

WordPress Database Backup Question

Posted by topdog 272 days ago Questions| database backup wordpress All

I am working on a charity site and was tasked with moving a WordPress site to another host from Yahoo hosting. I have done this before and thought it would be easy enough.

Before moving the site I backed up all the files and backed up the database. The files are fine, but the database backup has me stumped.

I ended up with the following file: mysqldata.2009-09-20-18-37.tar.gz

I thought I was in good shape and could just import the file using PHPmyAdmin, however, when I unzipped the file it is not a sql file at all but has the following structure:

blog mysql

Within the mysql director it has a list of files like this:

user.MYI columns_priv.frm columns_priv.MYD columns_priv.MYI db.frm db.MYD db.MYI func.frm func.MYD func.MYI host.frm host.MYD host.MYI tables_priv.frm tables_priv.MYD tables_priv.MYI user.frm user.MYD

Is there some way I can restore the database with the information in this form?

Thanks!

1 Answer Bury


Who Voted for this Question



Answers

comment-avatar
topdog
268 days ago
yeah... you saved the physical mysql files that hold the data instead of dumping the data so you could import it (mysqldump).
Rating: 1   up down

Log in to answer or register here.