Error in mysqldump when using numeric table names

2002-05-14 Thread Ronald Landheer
Hello all, When testing some of our Perl/DBI code, we made a couple of tables with numeric names (e.g. test.1 test.2 etc), because the code we're making has to be able to handle them correctly. It does, w/o any problem, but mysqldump doesn't: I get a message "mysqldump: Got error: 1064: You have

RE: Copying records b/w diff databases.

2002-04-25 Thread Ronald Landheer
Hi, if they have the same format (fields, etc): INSERT INTO db1.table1 SELECT (fields) FROM db2.table2 WHERE ...; Ciao, Ronald > -Original Message- > From: Charitha [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 25, 2002 10:23 > To: [EMAIL PROTECTED] > Subject: Copying records b/w d

RE: mysql gui over internet

2001-12-19 Thread Ronald Landheer
phpmyadmin run on an secure apache server.. you leave the security up to Apache and the MySQL admin is done with the phpmyadmin interface.. Apache: www.apache.org phpMyAdmin: http://sourceforge.net/projects/phpmyadmin/ Have fun! Ronald -Original Message- From: adam nelson [mailto:[EMAI