compress the backup as it's made:

mysqldump --opt -u_____ -p database | gzip -9 > /var/backups/blablabla.sql.gz

note: I have a small database (80mb or so), don't know if this will work on large databases or not

is there anywya to grab half or even quarter of the database at a time?

This is a very good syntax. Thanks for this. It's working very nice and quickly. :)

-Fish

I have been using:
/usr/local/mysql/bin/mysqldump --opt -u____ -p____ forums | gzip > /home/mysqldumps/backup/forums.sql
for a while now and it seems to work fine although I haven't had to restore from it.
What does the -9 switch do?

How do I expand my max_allowed_packet for mysql? I'm trying to restore my backup.sql on my local machine but I got an error saying that a line #: Got a packet bigger than 'max_allowed_packet'.

Thanks in advance!

mysqldump: Got error: 1044: Access denied for user: 'o0oKARo0X@localhost' to database 'o0oKARo0X' when using LOCK TABLES

What´s that error?

looks like a permissions problem. Make sure 'o0oKARo0X@localhost' is in your grant table

Yes it is but I can?t solve it, it?s getting very annoying :(

You may not have permission to use certain SQL commands with that username, give it access to everything (ALL) if you are unsure on what commands you need.

237: Got a packet bigger than 'max_allowed_packet'
How can I fix it?

Your host has to tweak the mysql settings in my.cnf to fix that. Make them do it, do not accept no for an answer.

I used Secure SSR and I find this file on my server:
*my.cnf (the name is crazy:(=
How can I replace "max_allowed_packet" to correct value? and how can I find the file my.cnf on my server .`? My server is using cpanel

i setup everything, when i type in my password

and click connect

Shell access is not enabled on your account!
If you need shell access please contact support.

Then that is just what you need to do. Most hosts will give you access on request without a problem.

well my old host http://elite-forumz.net i wana restore database to http://elite-forumx.net but the databse is 8 MB, any other way??

< advertise >

https://vborg.vbsupport.ru/showthread.php?t=78486

Is your easy answer to a reliable backup :)

< / advertise >

:)

This is cool when your server have SSH access, mine now has !

note that if your host isn't localhost by default you must use:

mysqldump --opt -u USERNAME -p -h SERVER DATABASENAME
mysql -u USERNAME -p -h SERVER DATABASENAME

you must then change SERVER, USERNAME and DATABASENAME to your values.

Thanks Teck for this !