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

moving MySQl database

2003-08-20 Thread Jon Miller
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 030820 23:48:08 mysqld ended When I issue #/ /usr/share/mysql/mysql.server start Anyone have any idea what's gone wrong. I changed the d

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

Moving MySQL database(s)

2001-04-05 Thread Graham Nichols
Hi, I've developed my mysql databases/tables on a local intranet server. What's involved in correctly copying them to an online linux machine please? regards, Graham Nichols