[rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread andrew fay
Hi, I am having a problem backing up the mysql db for our RT installation, I can back it up correctly into an SQL file.. move it to another machine with mysql running and get errors trying to restore it. If I remove the attachments table from the restore then it restores fine, the error i

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Ham MI-ID, Torsten Brumm
you try as workaround to stop your mysqld copy over the plain files (innodb etc) to the new server an try to start there. Tob Von: [EMAIL PROTECTED] An: rt mailing list Gesendet: Wed Jul 30 16:11:20 2008 Betreff: [rt-users] RT 3.6.4 MYSQL Backup Hi, I am

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Drew Barnes
*Gesendet*: Wed Jul 30 16:11:20 2008 *Betreff*: [rt-users] RT 3.6.4 MYSQL Backup Hi, I am having a problem backing up the mysql db for our RT installation, I can back it up correctly into an SQL file.. move it to another machine with mysql running and get errors trying to restore it. If I

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Ham MI-ID, Torsten Brumm
: Drew Barnes [EMAIL PROTECTED] An: Ham MI-ID, Torsten Brumm Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]; rt-users@lists.bestpractical.com rt-users@lists.bestpractical.com Gesendet: Wed Jul 30 16:35:44 2008 Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup I was thinking that it might

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Ham MI-ID, Torsten Brumm
Under xampp the is also a my.ini i think. Von: andrew fay An: Ham MI-ID, Torsten Brumm; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Gesendet: Wed Jul 30 16:46:44 2008 Betreff: RE: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup Hi

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Drew Barnes
the max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server. Thanks! Andy Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup Date: Wed, 30 Jul 2008 16:39:02 +0200 From: [EMAIL

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread andrew fay
just by itself with no luck. How would I set the max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server. Thanks! Andy Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup Date: Wed, 30 Jul 2008 16:39:02 +0200 From: [EMAIL PROTECTED] To: [EMAIL

Re: [rt-users] RT 3.6.4 MYSQL Backup*RESOLVED*

2008-07-30 Thread andrew fay
-users] RT 3.6.4 MYSQL Backup I have never used Mysql under windows, but from MySQL's documentation: When the MySQL server starts on Windows, it looks for options in two files: the my.ini file in the Windows directory, and the C:\my.cnf file. andrew fay wrote: Hi, Sorry I should

Re: [rt-users] RT 3.6.4 MYSQL Backup

2008-07-30 Thread Ham MI-ID, Torsten Brumm
2008 Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup Under xampp the is also a my.ini i think. Von: andrew fay An: Ham MI-ID, Torsten Brumm; [EMAIL PROTECTED] ; [EMAIL PROTECTED] Cc: rt-users@lists.bestpractical.com Gesendet: Wed Jul 30 16:46:44 2008 Betreff: RE

Re: [rt-users] RT 3.6.4 MYSQL Backup*RESOLVED*

2008-07-30 Thread Mathieu Longtin
@lists.bestpractical.com Subject: Re: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup I have never used Mysql under windows, but from MySQL's documentation: When the MySQL server starts on Windows, it looks for options in two files: the my.ini file in the Windows directory, and the C:\my.cnf file. andrew fay