Re: moving MySQl database

2003-08-21 Thread Michael Brunson
Check your ownerships and permissions. On Thu, 21 Aug 2003 00:27:05 +0800, Jon Miller used a few recycled electrons to form: | I've tried moving the database from one partition to another and now I'm getting the following error: | # Starting mysqld daemon with databases from /data/mysql | 03082

Re: Moving MySQL database(s)

2001-04-05 Thread Steve Werby
"Graham Nichols" <[EMAIL PROTECTED]> wrote: > I've developed my mysql databases/tables on a local intranet server. > What's involved in correctly copying them to an online linux machine Stop the mysql server on the intranet and FTP the files in the MySQL data directory to the MySQL data directory

Re: Moving MySQL database(s)

2001-04-05 Thread Roel Vanhout
$ mysqladmin -u -p create and then $ mysqldump -h -u -p | mysql -h -u -p or $ mysqldump -h -u -p > dbdump.sql $ mysql -u -p < dbdump.sql cheers, roel On Thu, Apr 05, 2001 at 05:06:24PM +0100, Graham Nichols wrote: > I've developed my mysql databases/tables on a local intranet ser