RE: Backup/Restore - Trimeloni, Adam - com.mysql.lists.eventum-users

5 messages in com.mysql.lists.eventum-usersRE: Backup/Restore

From	Sent On	Attachments
Brian	18 May 2005 06:13
Joao Prado Maia	18 May 2005 07:50
Trimeloni, Adam	18 May 2005 10:07
Brian	21 May 2005 21:59
Trimeloni, Adam	23 May 2005 13:10

Subject:	RE: Backup/Restore
From:	Trimeloni, Adam (ATri...@qsii.com)
Date:	05/23/2005 01:10:54 PM
List:	com.mysql.lists.eventum-users

For reference:

After Logging in MySQL Administrator Choose Health from the left hand menu Choose System Variables from the Tabs on the top right Choose Networking (under the Connections area) in the tree menu In the menu window on the right you will see "max_allowed_packet"

-- Adam

-----Original Message----- From: Brian [mailto:crim...@gmail.com] Sent: Saturday, May 21, 2005 10:00 PM To: EventumList Subject: Re: Backup/Restore

Thanks for the reply guys. Adam I am not sure where that cvar was so I did not try that yet. Joao, what you recommended worked (as far as I could tell), makes me wonder why MySQL Administrator hung up, unless the fix that Adam spoke of is it. Now on to issue 2, the database was imported into 4.1.12 and all "seems" to be in tact. I went ahead and edited config.inc.php on the web server with the new mysql db variables (host, database, username, password, etc...) but when I tried to connect I got a blank page at eventum/index.php. The web server did not change, just the DB, did I miss something in config.inc.phpor are there other files I need to edit?

On 5/18/05, Trimeloni, Adam <ATri...@qsii.com> wrote:

I don't know if it will make a difference for anyone else, but I practiced doing restores of my Eventum tables using MySQL Administrator (but my backup file was also created by MySQL Administrator).

The backup always started to hang due to a attached file being larger than my "max_alowed_packet" size in the MySQL server setup. I needed to increase that value to be larger than the attached file's size, after which, it always worked.

Regards,

-----Original Message----- From: Joao Prado Maia [mailto:jp...@mysql.com] Sent: Wednesday, May 18, 2005 7:50 AM To: 'EventumList' Subject: RE: Backup/Restore

Brian,

It is time for me to move eventum db from MySQL 3.23 over to MySQL 4.1.12. I currently use Webmin to do my backups. I tried taking the backup sql

to MySQL 4 and it hangs shortly after the import (using MySQL Administrator to import). I am thinking it has something to do with the attachments. Is there something I am doing wrong to backup attachments? Can someone point me in the right direction to properly

backup eventum db with attachments for a successful import?

Can you try running the normal mysql command-line client to do the import?

All you need is run something like the following:

mysql -u username -p eventum_db < backup.sql

See if that works for you.

--Joao