MySQL not dumping complete sql dump into mysql server, MySQL 5.5
Before I start with my question a little background. I guess my question should goto SO, but due to the SO screening system I am not able to post questions any more on SO. I am working on lifting these ban and need urgent response to my query so posting my question here. So please think before down voting and if possible consider migrating my question on SO to help me lift ban from my SO A/C. Coming to my question here it goes.
The other day I was taking backup of one of clients SQL data to restore the same, after formatting his system. Using the MySQL dump utility command line tool I was able to completely dump the entire system data. However post system format when we tried to restore the data using the same MySQL dump utility, about 70 percent of data was restored but the other 30 percent data was in SQL dump file but was still not dumped or restored back to the server.
Here is the overview I have 9 tables in my application database.
Table 1 to 5 have about 100 rows in table
Table 6 has about 25,000 rows
Table 7 has about 3000 rows
Table 8 and 9 have about 500 rows each.
After using the MySQL dump utility data for table 1 to 5 was completely restored. Structure for Table 6 and 7 were created but no data was dumped in them. They were completely empty and Table 8 and 9 were not created at all. We ended up copying these 28,000 rows of data manually for table 6 and 7 and had to manually create table 8 and 9 and also dump the data in same.
I tried to find but could not understand why MySQL dump utility did not work in these case and also if similar situation comes in future what can we do to restore the data. As the amount of data in future would be much more.
Thank you in Advance
Regards
Sanket
Before I start with my question a little background. I guess my question should goto SO, but due to the SO screening system I am not able to post questions any more on SO. I am working on lifting these ban and need urgent response to my query so posting my question here. So please think before down voting and if possible consider migrating my question on SO to help me lift ban from my SO A/C. Coming to my question here it goes.
The other day I was taking backup of one of clients SQL data to restore the same, after formatting his system. Using the MySQL dump utility command line tool I was able to completely dump the entire system data. However post system format when we tried to restore the data using the same MySQL dump utility, about 70 percent of data was restored but the other 30 percent data was in SQL dump file but was still not dumped or restored back to the server.
Here is the overview I have 9 tables in my application database.
Table 1 to 5 have about 100 rows in table
Table 6 has about 25,000 rows
Table 7 has about 3000 rows
Table 8 and 9 have about 500 rows each.
After using the MySQL dump utility data for table 1 to 5 was completely restored. Structure for Table 6 and 7 were created but no data was dumped in them. They were completely empty and Table 8 and 9 were not created at all. We ended up copying these 28,000 rows of data manually for table 6 and 7 and had to manually create table 8 and 9 and also dump the data in same.
I tried to find but could not understand why MySQL dump utility did not work in these case and also if similar situation comes in future what can we do to restore the data. As the amount of data in future would be much more.
Thank you in Advance
Regards
Sanket
No comments:
Post a Comment