A sql/select question.

table users iduser_iduser_name 1 M11 Shirley 2 M12 Bruce 3 M13 Fred 4 M14 Albert 5 M15 Elizabeth 6 T11 Helen 7 T12 Tracy 8 T13 Charles 9 T14 Jack 10 T15 Ann table

Backup table structure, not data

Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to another server and just delete records (a legacy database with data hitting over 12GB,

Re: Backup table structure, not data

# mysqldump --help look for the flag --no-data Ben Esbach, Brandon wrote: Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to

Re: Backup table structure, not data

Is there any way to backup a complete database structure (tables/fields/indexes/etc), without the data? Or even get a creation script per table? At present the only way I can think of is to restore a backup to another server and just delete records (a legacy database with data hitting over

Best way to combine MYISAM to MERGE tables ...

Hi All, I am working with MYISAM tables split by year, like: data2003, data2004, data2005, data2006, data2007, data2008, all having the same definitions. To speed up the query process, I also defined MERGE tables, like: CREATE TABLE data20032004 ... ENGINE=MERGE UNION (data2003,

RE: Backup table structure, not data

I ended up using mysqldump, worked well enough for what I was doing. I have to admit, I'm really surprised there's no way to do this directly in the admin gui that comes with MySQL though :). Thanks all for the replies! -Original Message- From: Richard Heyes [mailto:[EMAIL PROTECTED]

Re: Best way to combine MYISAM to MERGE tables ...

At 11:33 AM 2/18/2008, you wrote: Hi All, I am working with MYISAM tables split by year, like: data2003, data2004, data2005, data2006, data2007, data2008, all having the same definitions. To speed up the query process, I also defined MERGE tables, like: CREATE TABLE data20032004 ...

Re: A sql/select question.

2008/2/18 King C. Kwok [EMAIL PROTECTED]: table users iduser_iduser_name 1 M11 Shirley 2 M12 Bruce 3 M13 Fred 4 M14 Albert 5 M15 Elizabeth 6 T11 Helen 7 T12 Tracy 8 T13 Charles

Mysql5.0 Connector J issue with Tomcat 4

Dear Person in charge: We recently replaced mysql 4.0.16 with the free version of mysql 5.0.45 and the access from Tomcat 4 to the database has stopped working. It says java.sql.SQLException: Communication failure during handshake. Is there a server running on 192.168.2.34:3306? The server

RE: MYSQL Limit

I am trying the following code on 4.1.2 and getting a syntax error that I could not figure out. It works fine on 5.x. Any suggestion/alternate CREATE TEMPORARY TABLE Temp (Node INT, comm_id INT, INDEX USING BTREE (comm_id)) ENGINE = MyISAM; INSERT INTO Temp SELECT recipient, id FROM

Re: A sql/select question.

Hi Rob, That is just what I need. I can't use 'join' very well yet. Thank you very much. -- King Kwok -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Call PHP file from MySQL

Hi, Is it possible to call from within MySQL an external PHP script ? I've read MySQL Stored Procedure Programming from O'Reilly but found nothing :( How can I do this ? Any help would be appreciated. Warm Regards, Mário Gamito -- MySQL General Mailing List For list archives:

RE: Backup table structure, not data

This works fine for me: http://www.mysql.com/products/tools/administrator/ -Original Message- From: Esbach, Brandon [mailto:[EMAIL PROTECTED] Sent: Monday, February 18, 2008 12:22 PM To: [EMAIL PROTECTED] Cc: MySQL User Group Subject: RE: Backup table structure, not data I ended up