NAVIGATION -  HOME |  | |
| MySQL dumping and restoring problems | | Published by: jane 2009-01-07 |
Backup MySQL and manage MySQL database server : mysql backup ::
mysql backup, mysql restore and administrate mysql databases on the web without limitations? (secure transfer, no problems with firewalls)
http://www.dumptimer.com/HOME |
I just upgraded to a new server.
On the old server, the database had 9850 threads.
After dumping it and then restoring it on the new server, the database now only shows 4522 threads.
The weird thing is, all the posts (and the "lost" threads) are still in the database, just not visible - to me as well as to vB. I know this, because when I attempt to post a new thread, it gets appended as a reply to the end of one of the "invisible" threads, with all the previous posts in that thread still intact. The subject of that thread, though, has been changed to the new subject that I had entered.
Mysql dump restore section at Free Download Manager::
MySQL Backup / MySQL Dump and MySQL Restore scheduler (windows based) for MySQL Databases, local or remote in the Web. The MySQL Dump Timer offers access to
http://www.freedownloadmanager.org/downloads/mysql_dump_restore_info/HOME |
How to restore MySQL database from sql dump file? - Techie Corner::
To restore mysql database from a dump file, just type the command below:- mysql -u this will solve your problem. you do not need to have mysql>
http://www.techiecorner.com/31/how-to-restore-mysql-database-from-sql-dump-file/HOME |
I thought perhaps the data had been corrupted, so I restored the database again. And the same thing happened.
Any ideas as to what's wrong?
I'll gladly pay someone to figure this out for me, and fix everything. Download Access Dump Mysql Php Dump Software: MyDbDump, MyDbDump ::
Free Access Dump Mysql Php Dump Downloads Shareware, Freeware, Demos. Users can to RESTORE the backup data to the remote MySQL database server.
http://www.bluechillies.com/list/access-dump---mysql-php-dump.htmlHOME |
Backup and Restore MySQL Database Using mysqldump::
Instead of importing data, if you want to backup and restore MySQL database, In my experience, I’ve got some troubles when dumping tables and restoring
http://www.thegeekstuff.com/2008/09/backup-and-restore-mysql-database-using-mysqldump/HOME |
After hours of deliberating this with Steven (thanks buddy!) we've discovered that the old database had 9850 messages in the thread table, but only 4521 in the query.
That's probably why it's only transferring 4521 threads.
Any ideas on how to resolve this?
Please help! My board has been inactive for days, my users are frantic!
I'm having the same problem too. Lost half my db while importing. Not sure why.
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
#If you have any other info about this subject , Please add it free.# | |
|
