Re: Restoring database files
Am 18.06.2012 13:25, schrieb a bv: I have a mysql database , which tables are archived and i remove some files (montly data, .frm .MYD, .MYI) from the servers disk to an external storage. And i also drop or flush these tables from phpmyadmin. If i need to look and query these offline mysql files what i need to do after copying the files back to the mysql path of the server? which query? * stop mysqld * copy back the files * start mysqld MyISAM tables and databases are simply plain files and folders including the database mysql which can be copied since mysql# exists without needing any magical command signature.asc Description: OpenPGP digital signature
Re: Restoring database with frm myi and myd
The db format is in innodb On Dec 17, 2007 5:38 PM, To Glace [EMAIL PROTECTED] wrote: Hello, A database which has been deleted need to be restored. There is no .sql dump file. All we have is the .frm, .myi and .myd files from /var/lib/mysql/DATABASENAME. Here are the steps I have taken: 1. Created a new empty database - NEWDB 2. individually restored all tables using the restore command: restore table TABLENAME from '/PATH/TO/FILES'; Most displayed.. The storage engine for the table doesn't support restore and only created the structure for the table and did not import the actual data. I am not sure where to go from here. The data itself need to be restored back and cannot get to this at all. Is there a different way to restore this information? How do I enable the storage engine to support restore? Any input would be greatly appreciated. Thank you: TG
Re: restoring database previous mysql version
if I have to put in one line, then just taka a copy (zip, gzip, tar or whatever) of your old mysql data directory, like /usr/local/mysql/data, and then restore it into your new data directory under 4.1.x, and this should be fine assuming you have taken care of other things, also please refer to the doc on mysql for the upgrade http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html http://dev.mysql.com/doc/refman/4.1/en/upgrading-to-arch.html Kishore Jalleda http://kjalleda.googlepages.com On 4/3/06, murat . [EMAIL PROTECTED] wrote: Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart Note: I have SSH Access. This is very important for me, thank you. _ Hava durumunu bizden ögrenin ve evden öyle çikin! http://www.msn.com.tr/havadurumu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: restoring database
snip i have written a bat file in which the data databackup has been taken in sql it runs automatically every 1 hour and sends a automatically through email now at the other end i have to manually restore the database can any one give me the codes to restore the database automatically in vb or as a bat file the databack up say for a database test is test.sql I am assuming you used mysqldump to create your test.sql mysql [-u user] [-ppassword] new_db_name test.sql If new_db_name already contains data within test.sql you may need to use something like --add-drop-table when you create test.sql. mysqldump --add-drop-table my_db test.sql HTH Graham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restoring database from hotcopy
Hi Travis, I have the database files, now how do I put them back into mysql? mysqlhotcopy simply copies the data files to another directory. To restore them, terminate the mysql server and then copy the files back to the mysql data directory (e.g. /var/lib/mysql/db name). Note that mysqlhotcopy fails to backup all data if you use table handlers that use different files to store the data (like InnoDB does). Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Restoring database from hotcopy
Do have the files actual files? Or do you have text files which were create from MYSQLDUMP? -Original Message- From: Travis Farmer [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 3:04 PM To: [EMAIL PROTECTED] Subject: Restoring database from hotcopy If it's not too much trouble this is slightly urgent. ~Travis I have the database files, now how do I put them back into mysql? Restore table doesn't seem to work. Thanks in advance, ~Travis _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php