Re: MySQL Lost 3 Weeks of Data
Michael, check all your connectivity settings (host and port) of all of the software that you use (backup scripts for example) especially if you connect via tcp/ip instead of via sockets. Check the error log, too. Did you move something on January, 20th (database)? From our own experiences it sounds to me it is most likely a failure in the human interface but I may be totally wrong. Good Luck! Regards, Frank. Schmuck, Michael schrieb: Hello I've got a big problem. My MySQL server has yesterday lost data since 20th january. Fact, we got a daily tape backup. All our tapes (monday - friday tapes, oldest one is we 04th feb) are holding the database of 19th january evening. Yesterday at about 14 o'clock we resartet the demon on our bsd server since september 03. I belive the deamon didn't wrote the data into the files. At the restart of the database he loaded the old files and lost erverything newer then 20th. Everyone in my company says thats impossible (lost during restart of deamon). Everyone else says somthing wrong with the database update software, but the user worked all feb with this data. Wed morning he says he could work with it, but after our restart the database was like 19th jan. Has someone ideas why this happened? I couldn't explan to me why this happened! grds, Michael Schmuck p.s. sorry for bad english -- Dr. Frank Ullrich, DBA Netzwerkadministration Heise Zeitschriften Verlag GmbH Co KG, Helstorfer Str. 7, D-30625 Hannover E-Mail: [EMAIL PROTECTED] Phone: +49 511 5352 587; FAX: +49 511 5352 538 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Lost 3 Weeks of Data
Schmuck, Michael wrote: I've got a big problem. My MySQL server has yesterday lost data since 20th january. Yesterday at about 14 o'clock we resartet the demon on our bsd server since september 03. I belive the deamon didn't wrote the data into the files. At the restart of the database he loaded the old files and lost erverything newer then 20th. What do you mean: he loaded the old files and lost everything newer than 20th. Did he restore from a backup tape? If so, then it's probably a problem with your backup system not properly backing up the mysql tables. While the Mysql process is running, the files are in-use by Mysqld, and many tape-backup programs cannot properly copy files that are in-use. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Lost 3 Weeks of Data
Hello I've got a big problem. My MySQL server has yesterday lost data since 20th january. Fact, we got a daily tape backup. All our tapes (monday - friday tapes, oldest one is we 04th feb) are holding the database of 19th january evening. Yesterday at about 14 o'clock we resartet the demon on our bsd server since september 03. I belive the deamon didn't wrote the data into the files. At the restart of the database he loaded the old files and lost erverything newer then 20th. Everyone in my company says thats impossible (lost during restart of deamon). Everyone else says somthing wrong with the database update software, but the user worked all feb with this data. Wed morning he says he could work with it, but after our restart the database was like 19th jan. Has someone ideas why this happened? I couldn't explan to me why this happened! grds, Michael Schmuck p.s. sorry for bad english
Re: MySQL Lost 3 Weeks of Data
First and foremost, your English is not even remotely bad! You should hear half of my native-English speaking friends! Can you give us some more information, such as the server configuration, OS, filesystem, MySQL version, table types in use, table size, size of the data gone missing, backup methods and anything else worthy of note (forms of logical volume management, impatient users that reboot servers because they can't look at www.insert terrible site here.com due to proxy/firewall restrictions)? Regards, Chris Schmuck, Michael wrote: Hello I've got a big problem. My MySQL server has yesterday lost data since 20th january. Fact, we got a daily tape backup. All our tapes (monday - friday tapes, oldest one is we 04th feb) are holding the database of 19th january evening. Yesterday at about 14 o'clock we resartet the demon on our bsd server since september 03. I belive the deamon didn't wrote the data into the files. At the restart of the database he loaded the old files and lost erverything newer then 20th. Everyone in my company says thats impossible (lost during restart of deamon). Everyone else says somthing wrong with the database update software, but the user worked all feb with this data. Wed morning he says he could work with it, but after our restart the database was like 19th jan. Has someone ideas why this happened? I couldn't explan to me why this happened! grds, Michael Schmuck p.s. sorry for bad english -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]