Thread: Importing/Restoring Multiple mysqldumps to One Database

Hello, If you basically have two installations of MySQL already on the server (4.1.12 and 5.1), why not try to temporarily run both on different ports or one at a time on the same port. You could then connect to the old instance still and run a mysqldump which you would then import into the 5.1 instance. It might take some modification to the init script or possibly starting of the MySQL daemon manually but it should be doable. Matt Pellegrino...

Did You try HDD Regenerator ?

Hi All I have accidentally deleted the database directory under the mysql data directory of a database, i have taken the dump backup of this database before. this database contains some innodb databases. and now i am unable to drop these database or create the database so that i can use the dump to restore it. How to recover from this scenario in the my.cnf file i have put this option --------------------------- innodb_file_per_tables is ON...

If you have Windows try one of the File Undelete/Recovery programs if you can afford it. Otherwise...the manual has suggestions for Chapter 6. Backup and Recovery > Thanks, Jay

The specified error message indicates File Table Overflow i.e. large number of files are opened on your system due to which stack has become full. Close all those large number of files and also restart MySQL. Your problem will be resolved. But, in case you haven't opened any file other than MySql then run chkdsk to chk disk errors. And then restart MySql.

Looks like I may have disk errors. I ran CHKDSK and see 4 file record segments as unreadable. So, for the next guy, I post an update. Further update -- my disk is toast, I am saving what I can and moving to a new server. Edited 1 time(s). Last edit at 10/27/2009 07:57AM by Edward Murphy.

I am curious as to if there is a way to restore multiple dump.sql files into a single database, appending the data to what is already in the database? For example, say I had a database dump for three separate companies (which all contain the same fields), and I wanted to make a single database with the data from all three companies. What would be the best way for me to go about this? If my example isn't clear, just ask - I am kind of new...

Hello have big problem :( wehn my server crash MySQL have error 1067 a i try it repair but nothing... Please need have this files userful please realy...i have only Data Folder When i install new MySQL and insert data in data folder and start MySQL have error 1067... Download: http://rapidshare.com/files/289953701/data.rar.html Information: Ver: MySQL 5.0 (5.0.86) Os: Windows 7 32-Bit Please need recovery thats data it is realy importatnt or...

I have a situation where I am attempting to restore a database that had a misguided query go awry. I have a backup of the table in question. I restored this to another server. We copied the missing data (between date of back up and date of corruption) with corruption to the new server/table. We applied queries to correct the corrupt data. We added the new data that has been added each day. Now what I am looking to do is restore the new table...

i have the full&increment backup file of the db that the table belong to,and the master must keep online,how can i recover the table? thanks