Oh, yes, I know this option. The problem is quiet different, because if I create a db using php with mysql_create function, I can use the name with minus foo-db.
Analizing the binary log I see the command > create database foo-db; and when the slave process the query, it returns an error. -----Messaggio originale----- Da: Roger Baklund [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 20 novembre 2002 12.02 A: [EMAIL PROTECTED] Cc: Massimo Bandinelli Oggetto: Re: Slave sincronize * Massimo Bandinelli > I've problems sincronizing a Slave DB with a Master. > > I've a db created with name "foo-db" from phpmyadmin but the > mysql shell doesn't accept > > > create database foo-db; > > Do you know something about this?? The '-' character makes this name difficult for the mysql parser to understand, it could be interpreted as "foo minus db" (even though this would not make sense in a CREATE DATABASE statement). Use backticks: mysql> create database `foo-db`; Query OK, 1 row affected (0.36 sec) -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
