RE: Moving a database

2004-08-06 Thread Mark Pittam
> -Original Message- > From: David Barron [mailto:[EMAIL PROTECTED] > Sent: 06 August 2004 14:56 > To: [EMAIL PROTECTED] > Subject: Moving a database > > Good morning, > > What's the best way to move a database and all of its tables from one > server to another? > > Thanks You can use

RE: Moving a database

2004-08-06 Thread Mark Pittam
> -Original Message- > From: David Barron [mailto:[EMAIL PROTECTED] > Sent: 06 August 2004 17:10 > To: Mark Pittam; [EMAIL PROTECTED] > Subject: RE: Moving a database > > How do I recreate the database on the new server? Do I have to recreate > each table aga

customising mysql login message

2003-09-03 Thread Mark Pittam
Hi, I was wondering if it is possible to customise the message that appears when logging in using the mysql command line tool. When I connect using mysql I get the standard message below. This is the message I would like to customise with some extra information of my own. Does this information c

RE: Max Packet for MySQL?

2003-10-31 Thread Mark Pittam
Could you include the error you receive? You can check the current value of your max_allowed_packet using the following command, mysql> show variables like 'max_allowed_packet'; max_allowed_packet determines the maximum packet length that the server can send and receive. You can set this value