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
BTW, I found a way to get the data restored. If I run the MySQL command
prompt and do Source //risa/backup/data/fccamp.sql; it executes the SQL in
the back up file, and seems to restore all of the data. Why the MySQL
Administrator doesn't work is beyond me. I would rather that it does, but I
do
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),
