I'm copying the latest incarnation of my database onto my test platform so that I can run a test upgrade to the newest vB. The mysql import of the data has been running for almost 2 hours and it's still working on the post table. (ugh!)
Is there a better/easier way to go about this? I'd LOVE to just drop all the posts and copy everything else over, since I really don't need a copy of 1 million posts on my test platform. And if I hose this DB (which I very well might, since I'll be fiddling around) doing it all over again would really not make my day.If you can live with downtime, shutting down live and new mysql server and copying the database data files *.MYD, *.FRM, *.MYI over to new server/new database's directory and setting back correct user/group permissions on data files and restarting mysql server is another way to do it.Copy one table only, to a remote server.
$ mysqldump livedb post ssh user@remote.server.com mysql backupdb
You might want to look at Snapshots, to sync your data, incrementally.#If you have any other info about this subject , Please add it free.# |
|
9 January 2009 |
cameltoepants.com |
edit
