Re: [PHP] Where does mysql keep the records data

To delete a database, the best thing to do is login to your mysql DB directly, ie: mysql -u root -p (the root user is the MySQL root, not the sytem root) and supply the password at the prompt. Then do: DROP DATABASE publish; This will delete it "correctly". Something that I do is put all

Re: [PHP] Where does mysql keep the records data

On Monday 29 October 2001 07:51 am, you wrote: > I needed to start over with the work on publish so I deleted the publish > directory. #rm -R /var/db/mysql/publish. Um, not that it's PHP-related, but... You should use "drop database" instead of manually removing the file. mysql> drop database d

[PHP] Where does mysql keep the records data

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 /var/db/mysql/publish. 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-creat