MySQL exporting
- Started
- Last post
- 15 Responses
- ********
Could someone here shine some light on how to export a Wordpress MySQL database from one server to another without fucking it all up like I have now.
- unfittoprint0
if you have access to an admin, like PHPMYAdmin, just export all tables [structure and data] uncheck 'export as hexadecimal', and voilá, you have an .sql file with all your db.
- ********0
yeah I got that far, and also imported it again on the other server, but it wont really import it properly.
- unfittoprint0
how so?
- ********0
all the my blog entries get a 404 when clicked on.
- UndoUndo0
when you import the data phpMyAdmin will give you a message saying whether it was successful or not. do you get that?
- unfittoprint0
that 404 might have nothing to do with your mysql import being successfull.
it may have to do with db access from your php/asp scripts.
- ********0
I get a successful import, but i think it might be the way I export it , that fuck up things. I have no clue what I'm doing!
- unfittoprint0
you might have a different log/pass to access your db.
or u may be exporting only a structure...
can u browse your table rows to check for something strange?...
- ********0
Deleted and imported again.
Import has been successfully finished, 103645 queries executed.
and now it really screw things up
- UndoUndo0
when exporting the SQl try using the 'DROP TABLE IF EXISTS' option, this will clear any previously created tables and create it with new data from fresh
- ********0
Will try it out..
thanks for the help guys!
- PublikStar0
Dreamhost problems, right?
- ********0
yes! got a solution?
- PublikStar0
thought so!
wish i know how to do mysql transfer.
Good luck dude ;)
- ********0
got it working I think.. thanks again for the help.!