Re: Help restoring database: MacOS Server (Snow Leopard)
Okay, panic over. I recursively stripped the ACLs and things are working. Next time I drop a table from phpMyAdmin, I'll carefully read the little thing that pops up saying I'm about to drop an entire database... :-( One gets so yea, whatever to warning notifiers...) Thanks to all who sent helpful suggestions! On 2013-01-09, at 07:33, Jan Steinman wrote: I accidentally dropped a crucial database. My only backup is via Apple's Time Machine. First, I stopped mysqld and copied (via tar) the database in question from the backup. Restarted, but drat -- most of the tables were apparently using innodb's ibdata1 file, as only the MyISAM tables showed up in phpMyAdmin. I copied the ibdata1, but then mysqld wouldn't start, complaining about no mysql.sock, which was odd, because it was there. I then copied (via tar) the entire set of all databases, but am still having problems, I think related to Time Machine's ACL lists and extended attributes. Anyone have experience and wise words on restoring a database from Time Machine? Thanks! Books are associated with communities of writers, printers, proofreaders and a host of other people with whom the writer interacts... Granted, there are some websites that provide well written and researched articles and information. Unfortunately, many are not. The Internet may be more of a time using machine than TV. And its usage is not always positive. -- Pat Murphy Jan Steinman, EcoReality Co-op The day Microsoft makes something that doesn't suck is probably the day they start making vacuum cleaners. -- Ernst Jan Plugge Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Help restoring database: MacOS Server (Snow Leopard)
I accidentally dropped a crucial database. My only backup is via Apple's Time Machine. First, I stopped mysqld and copied (via tar) the database in question from the backup. Restarted, but drat -- most of the tables were apparently using innodb's ibdata1 file, as only the MyISAM tables showed up in phpMyAdmin. I copied the ibdata1, but then mysqld wouldn't start, complaining about no mysql.sock, which was odd, because it was there. I then copied (via tar) the entire set of all databases, but am still having problems, I think related to Time Machine's ACL lists and extended attributes. Anyone have experience and wise words on restoring a database from Time Machine? Thanks! Books are associated with communities of writers, printers, proofreaders and a host of other people with whom the writer interacts... Granted, there are some websites that provide well written and researched articles and information. Unfortunately, many are not. The Internet may be more of a time using machine than TV. And its usage is not always positive. -- Pat Murphy Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Help restoring database: MacOS Server (Snow Leopard)
Am 09.01.2013 16:33, schrieb Jan Steinman: I accidentally dropped a crucial database. My only backup is via Apple's Time Machine. First, I stopped mysqld and copied (via tar) the database in question from the backup. Restarted, but drat -- most of the tables were apparently using innodb's ibdata1 file, as only the MyISAM tables showed up in phpMyAdmin. I copied the ibdata1, but then mysqld wouldn't start, complaining about no mysql.sock, which was odd, because it was there. I then copied (via tar) the entire set of all databases, but am still having problems, I think related to Time Machine's ACL lists and extended attributes. what means i think jesus show us the mysqld log signature.asc Description: OpenPGP digital signature
Re: Help restoring database: MacOS Server (Snow Leopard)
Hi, It is not very surprising that the database cannot recover from a Time Machine backup. This generally applies to any software that is running at the moment the backup is taken. The InnoDB is especially sensitive to taking what is called a 'dirty' backup because it has a cache. You may get some luck with innodb_force_recovery. Either way, it is going to be unpleasant experience best avoided by mysql-specific backup strategy. Peace Karen. On 09.01.2013, at 7:33, Jan Steinman wrote: I accidentally dropped a crucial database. My only backup is via Apple's Time Machine. First, I stopped mysqld and copied (via tar) the database in question from the backup. Restarted, but drat -- most of the tables were apparently using innodb's ibdata1 file, as only the MyISAM tables showed up in phpMyAdmin. I copied the ibdata1, but then mysqld wouldn't start, complaining about no mysql.sock, which was odd, because it was there. I then copied (via tar) the entire set of all databases, but am still having problems, I think related to Time Machine's ACL lists and extended attributes. Anyone have experience and wise words on restoring a database from Time Machine? Thanks! Books are associated with communities of writers, printers, proofreaders and a host of other people with whom the writer interacts... Granted, there are some websites that provide well written and researched articles and information. Unfortunately, many are not. The Internet may be more of a time using machine than TV. And its usage is not always positive. -- Pat Murphy Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Restoring database files
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? Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
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
Restoring database with frm myi and myd
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 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
restoring database previous mysql version
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 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]
restoring database
hai, 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 regards prathima -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Restoring database doesn't restore all tables
I could use some help with restoring a backup. I have a backup file, generated using the mysqldump command. This file is approximately one gigabyte in size. I use the following command to restore this backup file: mysql -u root DevDBs New.all.aca When the command is finished executing, I check my DevDBs database, and it has been updated, but not all tables that I'm expecting to be restored have been restored. Further, the DevDBs directory has only about 250 megabytes of data, rather than the one gigabyte I am expecting. Any help would be appreciated. Danny
Problem restoring database from a sql file created by mysqldump
Hi, I used the command similar to the following to dump out both the structure and contents of my database: mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql I got an error half way through restoring the database into another test database using the following command: mysql -u root -Dtradingata -htesthost c:tradingdatadump.sql The error is: ERROR 1064 at line 5420: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '' at line 1. It seems like mysqldump is having problems in dumping out the contents properly. I would be grateful if someone could shed some light on this. Perhaps things like what flag to use to delimit the contents correctly before the dump etc. Many Thanks. Regards, Gilbert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem restoring database from a sql file created by mysqldump
At 18:01 +0100 7/30/03, Gilbert Wu wrote: Hi, I used the command similar to the following to dump out both the structure and contents of my database: mysqldump -F -u root --opt tradingdata c:tradingdatadump.sql I got an error half way through restoring the database into another test database using the following command: mysql -u root -Dtradingata -htesthost c:tradingdatadump.sql The error is: ERROR 1064 at line 5420: You have an error in your SQL syntax. Check the manual that corresponds to you MySQL server version for the right syntax to use near '' at line 1. What does line 5420 of the dump file look like? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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
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
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