[SOLVED] Not able to restore mysql --all-database backup file

suresh.k · 11-19-2012, 04:30 AM

Hi,

I have taken backup of all mysql databases using following command,
#mysqldump -uroot -p --all-databases > test.sql
successfully backup completed.

Here when iam restoring test.sql into another server iam getting problem, i have executed below command to restore databases.
#mysql -uroot -p < test.sql

Error:ERROR 2006 (HY000) at line 7255: MySQL server has gone away

Thanks
Suresh

jsaravana87 · 11-19-2012, 05:52 AM

Quote:

Error:ERROR 2006 (HY000) at line 7255: MySQL server has gone away

1.Did you check whether mysql server is running .If its running . Increase the max_allowed_packet value in your mysql configuration and then restart then try to restore the dump backup

To backup mysql database with stored procedures and triggers
#mysqldump -uroot -p --all-databases --routines > test.sql

suresh.k · 11-19-2012, 06:42 AM

Hi Arun,
Works Fine..

Thank you.

I also have an issue on PPTP VPN in linux,
I posted it on this forum also but no replay's,
Can u please look into that.

Here the link http://www.linuxquestions.org/questi...ly-4175437222/