On my system the mysql and test databases are created in /var/db/mysql/

I created a database called publish and it likewise was stored in 

I needed to start over with the work on publish so I deleted the publish 
directory. #rm -R /var/db/mysql/publish.

BUT after re-creating the tables all the records still existed, so the 
records weren't in /var/db/mysql/publish. Where is it?

# rm -R /var/db/mysql/publish
# mysqladmin create publish
# mysql
mysql> use publish
mysql> CREATE TABLE eZAddress_AddressType (
   ID int(11) NOT NULL,
   Name varchar(50),
   ListOrder int(11) DEFAULT '0' NOT NULL,
   Removed int(1) DEFAULT '0' NOT NULL,

mysql> INSERT INTO eZAddress_AddressType VALUES (1,'Home address',1,0);
ERROR 1062: Duplicate entry '1' for key 1

Where dat data at?

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to