Re: Help! Problem moving MySQL data dir to a larger file system

2005-11-07 Thread David Logan
Hi Daniel, Check your permissions. Your mysqld process is probably trying to create the log file but can't and is telling you via the error code 13 message $ perror 13 System error: 13 = Permission denied $ Regards Daniel C. Mahoney wrote: I'm running MySQL (--ersion says "mysql Ver 14.7 Di

Help! Problem moving MySQL data dir to a larger file system

2005-11-07 Thread Daniel C. Mahoney
I'm running MySQL (--ersion says "mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir was in it's own filesystem, mounted at /mysql, but it's now filled up (it's a 15 GB partition and it has 1.5 MB free). I shut down MySQL (did a "k

Re: [newbie] moving mysql db to new server

2005-09-15 Thread Gleb Paharenko
Hello. > i'm having a backup of the entire drive, but no dump. In what way have you done the backup of the drive? Do you have an archive with files from the corrupted drive or a raw image (snapshot) of the file system? If you have an archive you can just copy the data directory to

Re: [newbie] moving mysql db to new server

2005-09-15 Thread Pooly
2005/9/15, Julien vander Straeten <[EMAIL PROTECTED]>: > hi all, > > my machine crashed and i'd would like to restore my mysql databases > on my new system. > i'm having a backup of the entire drive, but no dump. > > my system is mac os x.3 server. > is there a way to drag&drop some folders to my

[newbie] moving mysql db to new server

2005-09-15 Thread Julien vander Straeten
hi all, my machine crashed and i'd would like to restore my mysql databases on my new system. i'm having a backup of the entire drive, but no dump. my system is mac os x.3 server. is there a way to drag&drop some folders to my new system? thanks for your help :-) julien -- MySQL General

RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

2004-08-27 Thread James
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

RE: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

2004-08-27 Thread Lehman, Jason \(Registrar's Office\)
(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

Re: Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

2004-08-27 Thread andy thomas
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

Moving MySQL data from Windows 4.0.12 to Linux 4.0.18

2004-08-27 Thread Lehman, Jason \(Registrar's Office\)
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 data is displayed on a web page they show up as ?. I am sure that it has

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

2003-08-20 Thread Dathan Vance Pattishall
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

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

2003-08-20 Thread Michael S. Fischer
IL PROTECTED] > Subject: moving MySQL > > > 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? > > Thanks > > Jon L. Miller, MCNE, CNS > Director/S

Re: moving MySQL

2003-08-20 Thread Jeremy Zawodny
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

Re: moving MySQL

2003-08-20 Thread Brian Reichert
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

moving MySQL

2003-08-20 Thread Jon Miller
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? Thanks Jon L. Miller, MCNE, CNS Director/Sr Systems Consultant MMT Networks Pty Ltd http://www.mmtnetworks.com.au "I don't know the ke

RE: Moving MySQL data to RAMDisk

2003-08-19 Thread Wendell Dingus
EMAIL PROTECTED] Sent: Tuesday, August 19, 2003 8:35 AM To: MySQL Users Subject: Moving MySQL data to RAMDisk On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysq

Moving MySQL data to RAMDisk

2003-08-19 Thread Creigh Shank
On moving my data files from /var/lib to /mnt/ramdisk I seem to be missing something. I've changed every .ini and .conf file I can find (/etc/my.cnf, /etc/init.d/mysql, /etc/init.d/mysqld, /etc/php.ini and /etc/httpd/conf/httpd.conf (for DAV-lock)). MySQL seems to start ok, but when I use my

Re: Moving Mysql

2002-09-12 Thread walt
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

Re: Moving Mysql

2002-09-12 Thread Ken Menzel
> To: <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 12:41 PM Subject: Moving Mysql > 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! >

Moving Mysql

2002-09-12 Thread Soheil Shaghaghi
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 how I should do this. Can anyone please

Re: plan: moving mysql db to a fresh server! (help?)

2002-08-14 Thread louie miranda
15, 2002 11:02 AM Subject: RE: plan: moving mysql db to a fresh server! (help?) > I think its...okey > > > > R.B.Roa > Traffic Management Engineer > PhilCom Corporation > Tel. No. (Office) (088) 858-1028 > (Home) (088) 858-8889 > Mobile No. (63) (919-3085267) >

Re: plan: moving mysql db to a fresh server! (help?)

2002-08-14 Thread Paul DuBois
At 10:36 +0800 8/15/02, louie miranda wrote: >Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for >pc-linux-gnu (i686) >my db(var) resides in /usr/mysql/var/. I have this new server which i have >mysql too. >Now what im thingking about is, instead of dumping all database/tab

plan: moving mysql db to a fresh server! (help?)

2002-08-14 Thread louie miranda
Hi, i have redhat distro that runs a mysql Ver 11.15 Distrib 3.23.48, for pc-linux-gnu (i686) my db(var) resides in /usr/mysql/var/. I have this new server which i have mysql too. Now what im thingking about is, instead of dumping all database/tables on my old redhat server. Compressing and movin

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