updates during database dump

dump, close? Thanks. Kind regards. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: importing a dumpfile from with the mysql client

one I have wondered about myself. Is there a way in mysql to "attach" to session to issue a commit? -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 3:02 PM To: Luke Vanderfluit Cc: MySQL List Subject: Re: importing a dumpfile f

Re: Output to a file

t I get an error. Payne -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

importing a dumpfile from with the mysql client

e same original session now, cause problems? Thanks. Kind regards. Luke. -- Luke Vanderfluit. Analyst/Programmer. Internode Systems Pty. Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: innodb vs myisam

r 2006, Luke Vanderfluit wrote: To: mysql@lists.mysql.com From: Luke Vanderfluit <[EMAIL PROTECTED]> Subject: innodb vs myisam Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well

innodb vs myisam

Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well be trying to seek all over the disk looking for the right spot all the time. Does innodb do a better job at keeping the file on

Re: DBD::mysql::st execute failed: MySQL server has gone away

Ravi Prasad LR wrote: Luke, Yup. Basically if I do a particular query from the command line, I get the following error: === InnoDB: Error: tried to read 16384 bytes at offset 1 3469819904. InnoDB: Was only able to read -1. 060327 8:25:41 InnoDB: Operating syste

Re: DBD::mysql::st execute failed: MySQL server has gone away

' port: 3306 Source distribution = Your help is appreciated. Thanks. Kind regards. Luke -Sheeri On 3/24/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:*

DBD::mysql::st execute failed: MySQL server has gone away

Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:* DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if ($self-

4.0.18 restore dump file 'max_allowed_packet' error

Hi. I've got mysql 4.0.18 installed on a sun X4100 running solaris. This is just a 32 bit version of mysql. I've reverted back to this version after trying mysql 5, 4.0.26 and 4.0.18 64bit. Those versions were all unstable on 64bit, that is, the server would just go away for no apparent reason

dropping a database to reclaim space

Hi. I have a database that is fairly large and I'm doing some testing with 2 different mysql packages, one 32-bit, one 64bit, for comparison's sake. Now I've finished with one of the dbs and I want to reclaim the disk space. I've tried deleting a few (large) tables from the database, thinking

binlogs

Hi. I have a production server that has a whole series of -bin files. I want to get rid of them because they are consuming too much space. Can I safely delete them? Some date back to April of this year. I've seen the 'PURGE MASTER LOGS TO 'mysql-bin.0XX';' Thanks for any replies. Kind regards.

Re: [rt-users] Huge Attachments table in 3.4.4

Hi. Jesse Vincent wrote: On Tue, Oct 25, 2005 at 04:14:46PM +0930, Luke Vanderfluit wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user needs

Re: [rt-users] Huge Attachments table in 3.4.4

Hi. Ruslan Zakirov wrote: On 10/25/05, Luke Vanderfluit <[EMAIL PROTECTED]> wrote: Hi. I have upgraded RT from 3.0.11 to 3.4.4. Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is when a user ne

Huge table

Hi. I have upgraded RT Request Tracker. I'm using Mysql 4.0.18, Apache 1.3.27 (with static modperl module). The database we are using is quite large. The main problem we are having is that certain processes can take quite a long time. This is due to mysql churning through data. I'd like to find

copy database other than mysqldump

Hi. I'm using 4.0.18 and for legacy reasons I can't upgrade that. However I'm upgrading the database to a new schema. I want to copy the database before I make changes to the schema, so that if anything goes wrong, I can revert back. I have a dump file of the database but that is around 5GIG,

Re: database won't load after machine reboot

password). Then the grant statement did the trick. Thanks. Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Luke

Re: database won't load after machine reboot

Hi David. Thanks for your help. Logan, David (SST - Adelaide) wrote: Hi Luke, Have you tried doing another GRANT statement to ensure the name and password are indeed correct? That would be my next step. That way at least you are sure that the name/password combination are correct. I can't

Re: database won't load after machine reboot

og. I'm certain of the right username and password. So hmmm Kind regards. Luke. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message-

Re: database won't load after machine reboot

noDB: Started /myProgs/mysql/libexec/mysqld: ready for connections. Version: '4.0.20-log' socket: '/tmp/mysql.sock' port: 3306 Thanks David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268

Re: database won't load after machine reboot

Hi. For clarity, I'm running mysql 4.0.20 And I did start the mysql daemon. Luke Vanderfluit wrote: Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What co

database won't load after machine reboot

Hi. I have a database that is used with wordpress blogging software. Yesterday the server that it's running on reset itself. Since then I can't access the database. What could be going on here? Any ideas? Thanks. Kind regards. -- Luke -- MySQL General Mailing List For list archives: http://li

configuration directives 4.0.18

Hi. Where can I find a good explanation/description of the configuration directives for mysql as they appear in my.cnf? I've downloaded the 4.1 manual but can't seem to find a description of the directives. BTW. Is there a manual for 4.0.18 or 4.0 version? Thanks. Kind regards. -- Luke -

mysql install

thanks in advance christmas cheers, -- Luke Vanderfluit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma