restore problem

2013-09-08 Thread Trianon33
Hello all,As this is my first post to this list (though reading for some time yet), I maybe not complete in asking my question. Apologies for that.On the other hand, this is not a prio 1 problem, so if it takes some mailing, that's ok.I have a website on my private webserver, which consist of some

Re: restore problem

2013-09-08 Thread Trianon33
Hello, Thanks for your quick reply. I use WEBMIN and within the Webmin modules you can make simply a SQL backup, which is in fact a flat file consisting of MYSQL commands. Explains this enough? Thanks, BR Op 8 sep. 2013, om 21:02 heeft Luis H. Forchesatto luisforchesa...@gmail.com het

Re: restore problem

2013-09-08 Thread Michael Dykman
I would suggest that you test your backup file on another full-featured server to determine that it is a valid first. I have done a little work with the raspberry pi and I doubt that the mysql distribution for that platform comes with all the features your server-class ubuntu does, so it is quite

Re: restore problem

2013-09-08 Thread Trianon33
H, this remark makes sense, thanks for reminding that. Since I have a backup in SQl format (it is readable statements), I was thinking on splitting the backup file in several separate restores and execute them manually in consecutive order. Hmmm, the idea attracts me. Wait for some

Re: restore problem

2013-09-08 Thread Andrew Moore
I would suggest making a physical backup. Shutdown MySQL on source, copy datadir and start on the the destination server. (observe configuration differences between the two machines) *Benefits;* consistent backup of non-transactional files. *Drawbacks;* downtime required. On Sun, Sep 8, 2013 at

Re: Restore Problem

2006-05-17 Thread Jesse
don't have an explanation. Does anyone else? Jesse - Original Message - From: Jesse [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Tuesday, May 16, 2006 3:30 PM Subject: Restore Problem I've got a backup that is scheduled by MySQL Administrator, which appears

Restore Problem

2006-05-16 Thread Jesse
I've got a backup that is scheduled by MySQL Administrator, which appears to be happening without a problem. However, I just tried to restore that backup on my machine, and the data doesn't appear to be restoring properly. The original database was on our web server, where the backup occurs

Backup and restore problem

2005-05-20 Thread Peter Blajev
Hi, I have two identical machines in terms of OS and software installed (more info at the end of the message). I need to dump a database on the first machine and restore it on the second one. Here is step by step what I'm doing. == on server1 $mysqldump cerberus_database

Restore problem between MySQL on Win32 and MySQL on Linux?

2004-04-23 Thread g . lams
Hi All, I performed the backup (mysqldump -u username -p db backup.sql) of a database on a Win32 (4.0.15-max-debug) server in order to restore it on Linux server (4.0.15-9) When I try to restore it on the linux machine (with mysql -u username -p db backup.sql), there is an error saying:

Re: Restore problem between MySQL on Win32 and MySQL on Linux?

2004-04-23 Thread Victoria Reznichenko
[EMAIL PROTECTED] wrote: I performed the backup (mysqldump -u username -p db backup.sql) of a database on a Win32 (4.0.15-max-debug) server in order to restore it on Linux server (4.0.15-9) When I try to restore it on the linux machine (with mysql -u username -p db backup.sql), there

Re: Restore problem between MySQL on Win32 and MySQL on Linux?

2004-04-23 Thread g . lams
It works like a charme with the -Q option Thank you Gael Victoria Reznichenko [EMAIL PROTECTED] wrote on 23/04/2004 11.26.01: [EMAIL PROTECTED] wrote: I performed the backup (mysqldump -u username -p db backup.sql) of a database on a Win32 (4.0.15-max-debug) server in order to

Restore problem: Delete link points outside datafile at 0 - on MySQL 3.23.49, FreeBSD 4.4, PHP Version 4.3.0

2003-10-14 Thread Global Country of World Peace
When restoring tables from a backup, get: Op: repair // - this should always be restore according to manual Msg_type: info Msg_text: Delete link points outside datafile at 0 The datafiles seem to restore ok. Have rtfm'd, googled and mysql forumed, but to no avail. Is this something to worry