L PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
I should have added what I was using to do the transfer. I am using
phpmyadmin to do a dump to a gzipped file and then I am importing.
Thanks for the info.
-Original Message-
From: andy
(Registrar's Office)
Cc: [EMAIL PROTECTED]
Subject: Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18
On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote:
> I am switching from a Windows computer to a Linux computer and when I
> dump the data from Windows to Linux I have n
On Fri, 27 Aug 2004, Lehman, Jason (Registrar's Office) wrote:
> I am switching from a Windows computer to a Linux computer and when I
> dump the data from Windows to Linux I have no problem except for the
> fact that some of my characters have been converted to strange
> characters and when the d
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
If you can't turn off your db use mysql_hotcopy and copy the data over
NFS
-->-Original Message-
-->From: Brian Reichert [mailto:[EMAIL PROTECTED]
-->Sent: Wednesday, August 20, 2003 2:24 PM
-->To: Jon Miller
-->Cc: [EMAIL PROTECTED]
-->Subject: Re: moving MySQ
Sure, just shut down the database cleanly (mysqladmin shutdown), move
the data directory intact to the new filesystem, and start up again.
--Michael
> -Original Message-
> From: Jon Miller [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 20, 2003 8:41 AM
> To: [EMAIL PROTECTED]
> Subj
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote:
>
> We've run out of disk space and would like to move either the entire
> MySQL system or if possible move the databases. Can this be done
> without any difficulties?
Yes. If you're on a Unix-like platform, you can symlink one or more
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon Miller wrote:
> We've run out of disk space and would like to move either the entire MySQL system or
> if possible move the databases. Can this be done without any difficulties?
Yes, if you can afford to turn off your server.
If you need to keep yo
MySQL is pretty good about following symlinks. Move /var/lib/mysql to
/mnt/ramdisk/mysql and then symlink to it.
# ln -s /mnt/ramdisk/mysql /var/lib/mysql
Changing where everything resides in my.cnf should have been sufficient
but the symlink way works great as well. And there should be no
perfor
Soheil Shaghaghi wrote:
> Hello everyone,
> I have my MySQL database n the var partition of a FreeBSD server.
> The problem is that the partition is almost full, and now I can't start the
> SQL server!
>
> I am thinking of moving the MySQL data directory to another partition, but I
> don't know h
Hello,
First shutdown mysql. The move or copy databses to new directory.
Restart server using --datadir=/my/path/for/data or place info in
my.cnf file. (See examples provided with MySQL code).
Ken
- Original Message -
From: "Soheil Shaghaghi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTE
"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
$ 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
13 matches
Mail list logo
