How To Restore 1 Database Out Of A File Containing Many
Apr 24, 2008
i found out that for the past 6 months ive been backup up all my MySQL databases into one big file. However, now that i actually need to restore a database, i can't find out how to actually restore 1 database out of this enormous file.
I can find the Mysql shell command to restore 1 database ... but it doesnt tell me if you need to have a 1 database dump file for this as well. It does not mention what happens if you execute that command on the big file containing all databases. Restoring all server databases would be a very bad thing.
I have on my server vBulletin 1.7GB database in SQL format I try somany time to restore it but its hang! I transfer that file to another server and its working fine!
I have a site which uses vBulletin. After a long story we ended up with the need to restore it's database from a backup.
The backup proccess was in fact copying the database files - .MYD, MYI; so no mysql dumps.
I've recreated the dabase from phpmyadmin and created a standard user wtih read/write permissions and a dba user.
After that I've copied the database files from the backup and when I've tried to launch the site, it gives me the error:
"Warning: mysql_query(): Unable to save result set in /includes/class_core.php on line 354"
That's all the output I get.
I've modified the files permission to 755 and changed the owner and group; I've modified the vBulletin file to use the dba user account to access the database... all this without any luck.
I've done some searching and I've found that restoring database .MYI/.MYD files is simple - stop mysql, copy files, set permissions and fire up mysql. I've replicated the steps but still doesn't work.
my site is down for 2 days. this started 2 weeks ago when the vps started to work very bad and my site has been down more time than up. they closed the topic: "horrible experience with liquidweb" [url] but I still have not a solution and now somebody accidentally I suppose, deleted the database.
I cant do nothing and my last backup i have here is from +1month ago..
in cpanel I see: "sql disk usage": 120 mb but in databases zone it doesnt appear and phpmyadmin access is denied.
forum cant be accessed:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/.../public_html/forum/db/mysql4.php on line 48
Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 330
Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/.../public_html/forum/db/mysql4.php on line 331 phpBB : Critical Error
Could not connect to the database
what can I do? can they restore it?
My sport community is in the worst nightmare I could imagine :-(
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
Unable to restore database '17' Not valid backup: Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.). VERIFY DATABASE is terminating abnormally.
(Error code 22) ---------------------- Debug Info -------------------------------
I've restored a cpmove file copied from another server and I notice that many site files are missing. However, there were no errors during the restore process in WHM.
When I try to manually gunzip the file, I get an "unexpected end of file" error.
Questions -
1. If the file is corrupt or was transferred in ASCII instead of binary, would any of it have been expected to restore properly? For example, I can see the database content is valid, as are some of the php files and such.
2. I no longer have access to the source server. Is there a way that this file can be repaired?
3. Why didn't WHM report any error when extracting the tarball?
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
when i want to Restore full backup see this error Restore for cpmove-wwwpakh.tar.gz Searching /home.... checked 25 files..... No Restorable archives found! Searching /usr/home.... checked 0 files..... No Restorable archives found! Searching /web.... checked 0 files..... No Restorable archives found! Searching /home2.... checked 0 files..... No Restorable archives found! Searching /home3.... checked 0 files..... No Restorable archives found! Searching /root.... checked 12 files..... No Restorable archives found! Searching /usr.... checked 16 files..... No Restorable archives found! No archives where found for user wwwpakh.tar.gz! This feature will restore full backups, cpanel backups and cpanel move files in the format of: cpmove-user.tar.gz, user.tar.gz, backup-date_time_user.tar.gz The files must be in one of these directories on the server: /home,/usr/home,/web,/home2,/home3,/root,/usr
You must upload the file to one of the above locations before using this feature.