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
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 res
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
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"
het volgende geschreven:
> How
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
but I
don't have an explanation. Does anyone else?
Jesse
- Original Message -
From: "Jesse" <[EMAIL PROTECTED]>
To: "MySQL List"
Sent: Tuesday, May 16, 2006 3:30 PM
Subject: Restore Problem
I've got a backup that is scheduled by MySQL Administrator,
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 ea
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 > cerberus_database-
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 orde
[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),
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:
ERR
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 worr
12 matches
Mail list logo