I am having huge problems migrating large db’s from one server to
another. I use phpmyadmin to dump the data into a file, and then
migrate it to my production server. Then I try to use this:
mysql dbname < filename
but if the tables are too large, it simply does not work.
So I tried the following two work-arounds, which work but are tedious.
Is there a nicer way to do it:
Solution A: Create a dump file with subset of all the tables, to
reduce size
Solution B: Take a zip of the table structure directly, and then copy
that. Problem here is that all the tables have to be individually
"repaired" so that mysql is in synch with its new data.
Is there any other "good" solution?
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Proble...ict121440.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=404507