Hi Martin,
On 4/12/2016 07:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to
start up again. The data directory consists of a mix of ISAM and Inno tables.
I was able to copy the ISAM tables into a new 5.6 version, and they work
Hi Martin
On 4/12/2016 07:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to
start up again. The data directory consists of a mix of ISAM and Inno tables.
I was able to copy the ISAM tables into a new 5.6 version, and they work.
I
On 12/3/2016 14:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database
There's been 5.0m 5,1, 5,4 (briefly), 5.5, 5.6 and now 5.7. No 5,.2.
that quite suddenly andthat I wasn’t able to start up again. The data
directory consists of a mix of ISAM and Inno tables.
You mean M
Am 03.12.2016 um 21:23 schrieb Martin Mueller:
In my case, I can reproduce Time machine backups of data directories at varying
times. At one point I was able to replace the non-working installation with an
earlier installation, but then it failed unpredictably.
Are the Inno tables on Time Ma
I abandoned a MySQL 5.22 database that quite suddenly andthat I wasn’t able to
start up again. The data directory consists of a mix of ISAM and Inno tables.
I was able to copy the ISAM tables into a new 5.6 version, and they work.
I understand that INNO tables are different because different
etreff: Re: --initialize specified but the data directory has files in it.
Aborting.
[root@deweyods1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server
release 6.6 (Santiago)
On Fri, Nov 13, 2015 at 8:56 AM, Reindl Harald
wrote:
>
>
> Am 13.11.2015 um 17:46 schrieb Axel Diehl:
>
>
:01.207712Z 0 [ERROR] --initialize specified but the data
directory has files in it. Aborting.
2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting
can someone help?
thank you,
Jim
You attempted to install a new 5.7 on top of an existing set of data.
Quoting from
http://dev.mysql.com/doc/refman/5.7/en
on: jim Zhou [mailto:jim.jz.z...@gmail.com]
>> Gesendet: Freitag, 13. November 2015 17:12
>> An: mysql@lists.mysql.com
>> Betreff: --initialize specified but the data directory has files in it.
>> Aborting.
>>
>> Hi,
>>
>> I did "yum install myswl
ckages are better maintained
-Ursprüngliche Nachricht-
Von: jim Zhou [mailto:jim.jz.z...@gmail.com]
Gesendet: Freitag, 13. November 2015 17:12
An: mysql@lists.mysql.com
Betreff: --initialize specified but the data directory has files in it.
Aborting.
Hi,
I did "yum install myswl-c
Hi,
what kind of OS do you have?
Regards,
Axel
-Ursprüngliche Nachricht-
Von: jim Zhou [mailto:jim.jz.z...@gmail.com]
Gesendet: Freitag, 13. November 2015 17:12
An: mysql@lists.mysql.com
Betreff: --initialize specified but the data directory has files in it.
Aborting.
Hi,
I did &quo
Am 13.11.2015 um 17:37 schrieb jim Zhou:
I change socket=/tmp/mysql.sock in my.cnf file and I am still having the
same error.
ls -lha /var/lib/mysql the directory is not empty. those .pem files are
created by the service even I deleted them.
write a bugreport if they are really created by the
[ERROR] --initialize specified but the data
directory has files in it. Aborting.
2015-11-13T15:54:01.207751Z 0 [ERROR] Aborting
this is most likely because the socket file lives by default in
"/var/lib/mysql" and maybe created too soon for the task
write a bugreport and in the meantime t
able_open_cache:
431 (requested 2000)
2015-11-13T15:54:01.204397Z 0 [Warning] TIMESTAMP with implicit DEFAULT
value is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).
2015-11-13T15:54:01.207712Z 0 [ERROR] --initialize specified but the data
di
The sequence number is
> 01 to 15. A new file is created every time MySQL is restarted. The
> 1.index file contains a list of these files. One thing that I have done is
> when I was hardening the security we stopped MySQL and moved the data
> directory to a directory cal
There are files beginning with 1.. The sequence number is
01 to 15. A new file is created every time MySQL is restarted. The
1.index file contains a list of these files. One thing that I have done is
when I was hardening the security we stopped MySQL and moved the data directory
to
Am 27.03.2013 19:53, schrieb Arnold:
> What are the *.index files in the MySQL Data directory? I notice a new one
> is created every time that MySQL is stopped and restarted. My Data directory
> is not in the default location so does that have anything to do with it?
maybe a "
What are the *.index files in the MySQL Data directory? I notice a new one is
created every time that MySQL is stopped and restarted. My Data directory is
not in the default location so does that have anything to do with it?
Thanks,
Sandra Arnold
Data Warehouse Administrator
MartinFederal
gt;>
>>
>> Hi there,
>>
>> I am using MySQL on ubuntu 8.04.
>>
>> I followed this link
>>
>> http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
>> to change the data directory of
jia mailto:chen.1...@gmail.com>>
>
> Hi there,
>
> I am using MySQL on ubuntu 8.04.
>
> I followed this link
>
> http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
> to change the data directory
audio Nanni wrote:
2009/8/26 chen jia mailto:chen.1...@gmail.com>>
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directo
.04.
>>
>> I followed this link
>>
>> http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
>> to change the data directory of MySQL.
>>
>> After stopping MySQL: sudo /etc/init.d/mysql stop
>&
o-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: sudo /etc/init.d/mysql stop
I make a new directory: sudo mkdir /media/disk/MySQL_data
then change the ownership of new directory, sudo chown mysql:mysql
/media/disk/MySQL_data
2009/8/26 chen jia
> Hi there,
>
> I am using MySQL on ubuntu 8.04.
>
> I followed this link
>
> http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
> to change the data directory of MySQL.
>
> After stopping
le search on
selinux and
> mysql should produce good results.
>
> On Tuesday, August 25, 2009, chen jia mailto:chen.1...@gmail.com>> wrote:
>
>
> Hi there,
>
> I am using MySQL on ubuntu 8.04.
>
> I followed this link
>
log, if you can't find it, start mysql from the
> > cmd line by running safe_mysqld it should print errors to console.
> >
> > If it is a permission issue, it might be caused be selinux, you'll
> > need to change the object type od that new directory to mysqld-
> &
it should print errors to console.
>
> If it is a permission issue, it might be caused be selinux, you'll
> need to change the object type od that new directory to mysqld-
> something. I can't recall the command. A google search on selinux and
> mysql should produce good results.
ood results.
On Tuesday, August 25, 2009, chen jia wrote:
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: s
nother-location-partition-or-hard-drive
> to change the data directory of MySQL.
>
> After stopping MySQL: sudo /etc/init.d/mysql stop
>
> I make a new directory: sudo mkdir /media/disk/MySQL_data
>
> then change the ownership of new directory, sudo chown mysql:mysql
>
Hi there,
I am using MySQL on ubuntu 8.04.
I followed this link
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive
to change the data directory of MySQL.
After stopping MySQL: sudo /etc/init.d/mysql stop
I make a new directory: sudo mkdir
boll wrote:
> I would like to know the correct way to move the mysql data directory to
> a different disk partition, so that the data can be accessed by mysql
> under linux or windows. I'm using Ubuntu 7.1 and Windows XP.
I wrote these steps for 4.0, I think they should work
I would like to know the correct way to move the mysql data directory to
a different disk partition, so that the data can be accessed by mysql
under linux or windows. I'm using Ubuntu 7.1 and Windows XP.
I copied the data directory to a separate partition.
I then changed the datadir in m
01:15 PM, Ahmad AlTwaijiry wrote:
Good morning everyone,
If I want to run MySQL server in Windows and Linux OS (dual boot
desktop), but I want to make the data directory (the one that has all
the databases tables and information) in one shared VFAT filesystem so
if I create a database while I'm
Good morning everyone,
If I want to run MySQL server in Windows and Linux OS (dual boot
desktop), but I want to make the data directory (the one that has all
the databases tables and information) in one shared VFAT filesystem so
if I create a database while I'm running in Linux and
On 1/26/07, Dominik Klein <[EMAIL PROTECTED]> wrote:
Michael Stearne schrieb:
> We have 5.0.27 installed on a CentOS machine that doesn't have a ton
> of disk space. Is it possible to point the data directory to lie on a
> samba connected share? The samba share does n
Michael Stearne schrieb:
We have 5.0.27 installed on a CentOS machine that doesn't have a ton
of disk space. Is it possible to point the data directory to lie on a
samba connected share? The samba share does not support Unix file
permissions so it is not possible to set mysql as the own
We have 5.0.27 installed on a CentOS machine that doesn't have a ton
of disk space. Is it possible to point the data directory to lie on a
samba connected share? The samba share does not support Unix file
permissions so it is not possible to set mysql as the owner of the
files. Is
i am working on a data collection system for an epidemiological study.
the study holds among other things sensitive personal information. the
personal info is stored in ONE table (i am using innodb_file_per_table)
which we encrypt and wipe after the server is shutdown.
the question is, where else
On 5/2/06, Yves Goergen <[EMAIL PROTECTED]> wrote:
But upgrading MySQL like installing it
after MySQL's guide brings a problem: I'd need to move the data
directory to the new programme directory every time.
That is what I do. I find it easier than moving the data directory t
On 03.05.2006 12:34 (+0100), Logan, David (SST - Adelaide) wrote:
> You could also have changed the directory in the global /etc/my.cnf file
> by setting
>
> datadir=/path/to/mysql/data
>
> This is pretty simple and works a lot easier than hacking the init
> scripts.
As I said, there are two MyS
t
---
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 3 May 2006 8:01 PM
To: paul rivers
Cc: mysql@lists.mysql.com
Subject: Re: How to move the MySQL data directory?
On 03.05.2006 01:21 (+0100), paul rivers
---
-Original Message-
From: Yves Goergen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 3 May 2006 8:01 PM
To: paul rivers
Cc: mysql@lists.mysql.com
Subject: Re: How to move the MySQL data directory?
On 03.05.2006 01:21 (+0100), paul rivers wrote:
> Specify the data
datadir/my.cnf to make
it read my socket name, IP & port etc.
Now both servers are up and running fine again, side by side, with the
*entire* data directory moved somewhere else, saving me from handling
that with every upgrade. Thanks for your help, I thought it could be
done an easy way but it seems
: Dan Buettner
Cc: mysql@lists.mysql.com
Subject: Re: How to move the MySQL data directory?
On 02.05.2006 22:24 (+0100), Dan Buettner wrote:
> The easiest way might be to tell mysql in the config file where to
> look for the data directory.
>
> In your my.cnf file (typically /etc/my.cnf)
On 02.05.2006 22:24 (+0100), Dan Buettner wrote:
> The easiest way might be to tell mysql in the config file where to
> look for the data directory.
>
> In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section:
>
> datadir = /Volumes/mysql-data/data
One of the
The easiest way might be to tell mysql in the config file where to
look for the data directory.
In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section:
datadir = /Volumes/mysql-data/data
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Well, moving the datadir to the new MySQL 5.0.21 directory, messing
around with all the stupid symlinks, it seems I have finally managed to
delete that datadir... It was empty anyway, yet, but this is an
extremely dangerous task. So I really need to move the datadir to a safe
place, outside all tha
Hello,
I've just wanted to update MySQL 5.0 on my test machine that will be a
productive server very soon. But upgrading MySQL like installing it
after MySQL's guide brings a problem: I'd need to move the data
directory to the new programme directory every time. So I want to m
boll wrote:
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev/[yourdev
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev/[yourdevicename] /your
boll schrieb:
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't c
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create test
Adam Alkins wrote:
Hi,
There's a mysqld startup option --datadir=/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote:
Hi All,
I am trying to find out ho
Hi,
There's a mysqld startup option --datadir=/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am trying to find out how to change
Hi All,
I am trying to find out how to change the location of the data files. I have
not yet found a generic entry for the my.conf file to set a data and log
location.
Can I move the exiting data directory form the mySQL tree and put a soft
link to a new location on another partition?
thanks
Mailing List
Subject: Newbie Query: Error starting MySQL..changed Data Directory
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata
Hi all
First usage of MySQL. Newbie in Linux as well as MySQL. Using CentOS 4.2
with MySQL 4.1.12, rpm install.
Changed the data directory.
My /etc/my.conf
[mysqld]
datadir=/home.dbdata/mysql
socket=/home.dbdata/mysql/mysql.sock
# Default to using old password format for compatibility with
sing MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of
> Debian, just to clarify). I had a setup of a program I've been working on
> for several years that is on a RAID. I changed MySQL's data directory so it
> will be on the same RAID and backed up, alon
I'm using MySQL 4.0.24-10 on Debian Sarge (Linux, and the stable branch of
Debian, just to clarify). I had a setup of a program I've been working on
for several years that is on a RAID. I changed MySQL's data directory so it
will be on the same RAID and backed up, along with al
Hey, sorry everyone - I figured it out.
I had to add the following to my.cnf
read-only
skip-innodb
I guess I shoulda kept googling before asking... mybad.
/JP
On 9/21/05, Jake Peavy <[EMAIL PROTECTED]> wrote:
>
> Hey yall,
> I'm trying to use a DVD (containing a number of packed MyISAM tabl
Hey yall,
I'm trying to use a DVD (containing a number of packed MyISAM tables in a
directory) as the datadir in my my.cnf but I can't start the server: mysqld
is trying to write to the datadir - error log, etc - and when it can't the
server craters.
Is there anyway of using a readonly directory
> Hi all,
>
> I have been using /var/mysql/data as my data directory till now ,
> suddenly i realise its all filled up with some 20M left which will
> finish in a day or two , repartioning my disks is not an option , what
> do i do to restart mysql with a new data directory say
Hi all,
I have been using /var/mysql/data as my data directory till now ,
suddenly i realise its all filled up with some 20M left which will
finish in a day or two , repartioning my disks is not an option , what
do i do to restart mysql with a new data directory say
/usr/local/mysql/data
er 12, 2003 8:26 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Changing Data Directory
>
>
> in my.cnf:
> [mysqld]
> datadir=/var/lib/mysql
>
>
> -Original Message-
> From: Daniel Kiss [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 12, 2003 3
in my.cnf:
[mysqld]
datadir=/var/lib/mysql
-Original Message-
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 3:21 PM
To: [EMAIL PROTECTED]
Subject: Changing Data Directory
Hi all,
How can I change the directory of the databases?
I have
Hi all,
How can I change the directory of the databases?
I have tries the basedir switch in the my.cnf [mysqld] section, but it did not work.
How should I do it?
Thanks,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
> At 4:22 PM -0400 9/19/03, Jeff McKeon wrote:
> >We've got mysql 3.23 installed on a redhat system via the rpm's that
> >come with RedHat 8.0. I'd like to change the default data
> directory so
> >something other than /var/lib/mysql. I know this is s
At 4:22 PM -0400 9/19/03, Jeff McKeon wrote:
We've got mysql 3.23 installed on a redhat system via the rpm's that
come with RedHat 8.0. I'd like to change the default data directory so
something other than /var/lib/mysql. I know this is supposed to be
possible with a start swit
We've got mysql 3.23 installed on a redhat system via the rpm's that
come with RedHat 8.0. I'd like to change the default data directory so
something other than /var/lib/mysql. I know this is supposed to be
possible with a start switch of --datadir=/path/to/data but it doesn
thanks for the valuable tips
sanjay gupta
- Original Message -
From: "Thierno Cissé" <[EMAIL PROTECTED]>
To: "'sanjay gupta'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 3:50 PM
Subject: RE: how to change d
thanks for valuable tips
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 04, 2003 3:30 PM
Subject: Re: how to change default data directory
> "sanjay gupta" <[EMAIL PROTECTED]> wrote:
27;ll see that the directories mysql and test are
placed under
Hope this help
Thierno6C
-Original Message-
From: sanjay gupta [mailto:[EMAIL PROTECTED]
Sent: jeudi 4 septembre 2003 09:35
To: [EMAIL PROTECTED]
Subject: how to change default data directory
Hi All ,
I am
"sanjay gupta" <[EMAIL PROTECTED]> wrote:
>I am using RH7.1 box . I am preparing to install mysql 4.0.13.
> Previously when i installed the mysql the mysql data directory was
> /var/lib/mysql . I uninstall the mysql . Now i want my data directory to be
>
Hi All ,
I am using RH7.1 box . I am preparing to install mysql 4.0.13.
Previously when i installed the mysql the mysql data directory was
/var/lib/mysql . I uninstall the mysql . Now i want my data directory to be
/var1/lib/mysql instead of /var/lib/mysql . I want this because var1
hoice and you've had great success with SAN's before as
mentioned .. stay the route...
On Tue, 8 Jul 2003, SAQIB wrote:
> Hello All,
>
> I am trying to decide which storage I should use for the "Data Directory".
> My application has lots of 'SELECT's (80%
www.vbmysql.com
> -Original Message-
> From: SAQIB [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2003 8:45 AM
> To: [EMAIL PROTECTED]
> Subject: NAS vs SAN for data directory
>
>
> Hello All,
>
> I am trying to decide which storage I should use for
Hello All,
I am trying to decide which storage I should use for the "Data Directory".
My application has lots of 'SELECT's (80%) and fewer
UPDATEs/INSERTs(20 %).
I have the following choices of Data storage
1) Xiotech SAN (66 Mhz FCAL)
2) NAS
3) Internal SCSI 3 RAID 5
Will
On Monday 03 February 2003 00:40, vim m wrote:
> Hi: I am new to mysql. I did an rpm install of
> ver-3.23.55 on RH 7.1.
>
> By default the data is stored in /var. Can I change
> this option.
Take a look at --datadir option of mysqld or you can also specify another
location of the data dir in th
Hi: I am new to mysql. I did an rpm install of
ver-3.23.55 on RH 7.1.
By default the data is stored in /var. Can I change
this option.
Thank you.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---
y" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 18, 2003 16:26
Subject: RedHat 8, mysql-server-3.23.54a-4 and relocating the data directory
Hi All! I'm new to the list, but I've been using MySQL under Red Hat for a
couple of years now.
I'm in the
Hi All! I'm new to the list, but I've been using MySQL under Red Hat for a
couple of years now.
I'm in the process of setting up a new Red Hat 8 box and I want to change
the data directory to a different location (/raidarray2/data/mysql). I've
edited the /etc/my.cnf
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Defryn, Guy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 4:00 AM
Subject: d
Where does mysql places the databases in 4.0.9 when installing from source?
The var directory does not seem to be there anymore
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
>Description:
followed instructions in manual to remove existing files in data directory and
replace. on doing so, get errors when i try to start using "sudo safe_mysqld
--user=mysql &". error log reads:
---
021210 17:05:07 mysqld started
Cannot ini
il:
JS> I shutdown and added /etc/my.cnf file:
JS> kaaawa# more /etc/my.cnf
JS> [mysql]
JS> datadir = /db_data/mysql_data
The section must be [mysqld], not [mysql]
JS> hide the installed data directory:
JS> kaaawa# mv data data.orig
JS> started up again:
JS> kaaawa# bin/safe
cal/mysql/data/mysql a softlink to a different place, but
> JS> that didn't work.
>
> What exactly doesn't work? Could you be more detailed?
Here's more detail:
I shutdown and added /etc/my.cnf file:
kaaawa# more /etc/my.cnf
[mysql]
datadir = /db_data/mysql_data
hi
Julia,
Tuesday, December 03, 2002, 2:24:49 AM, you wrote:
JS> I have just installed the mysql binary on solaris 8.
JS> I would like have the data go to a different directory than /local/mysql/data.
JS> How do I get it to do that?
JS> I tried starting it with the --datadir set, but that didn't wor
I have just installed the mysql binary on solaris 8.
I would like have the data go to a different directory than /local/mysql/data.
How do I get it to do that?
I tried starting it with the --datadir set, but that didn't work.
I tried setting datadir in the /etc/my.cnf file, but that didn't work.
I
Daren,
Wednesday, August 14, 2002, 11:49:22 PM, you wrote:
DC> My Linux installation only has about 1gb in the /var
DC> partition, so I need to relocate my databases to the
DC> /home partition. I'm pretty sure the following
DC> commands will shutdown mysql, move the data direct
What is the purpose of creating the symlink if I
manually edit the data directory variable? Would it be
better to:
a) Move the data, and edit the data directory to the
new location
b) Move the data, and create a symlink to the new data
TIA,
--- Rahadul Kabir <[EMAIL PROTECTED]>
My Linux installation only has about 1gb in the /var
partition, so I need to relocate my databases to the
/home partition. I'm pretty sure the following
commands will shutdown mysql, move the data directory,
create a symbolic link, and then restart mysql. My
question is, is this complete, or
Satish,
Friday, July 05, 2002, 9:26:23 PM, you wrote:
SS> I am a newbie to MySQL administratation. I just
SS> setup MySQL in my linux machine and want to change the
SS> data directory from /var/lib/mysql to something else.
SS> I put the .my.cnf file in the /etc/ directory and
S
Hi Guys,
I am a newbie to MySQL administratation. I just
setup MySQL in my linux machine and want to change the
data directory from /var/lib/mysql to something else.
I put the .my.cnf file in the /etc/ directory and
specified the parameter datadir=/home/mysql but it
gives me an error invalid
paste the directories into the /database/mysql directory. When I
executed scripts/mysql_install_db, it ran but the mysql directory was missing
mysql/data directory and so was the untared and ungzipped directory basically it was
nowhere. Is there something im missing.
Thanks
Sagine
A few weeks ago, my mysql 3.23.46 server spontaneously started changing
its data directory to /var/tmp/ once or twice a week, and once or twice
a day for a short span. Nothing in the error file. Anyone seen anything
like this or have any idea what's going on? I changed the data directory
Can the data directory reside on a different machine than the mysql program
itself, such as on a maxattach storage device.
Thanks,
stephen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
the insert command doesn't works on Win32,
>> is because the link file pointing for the DATA DIRECTORY wasn't
>> created in the create table command, like the Unix version does.
>> The Win32 OSs don't have a native symbolic link feature and the
>> today symboli
Hi!
>>>>> "Mike" == Mike Blazer <[EMAIL PROTECTED]> writes:
Mike> Well, I'm sure there are some better ways too - it's a pity that it such
Mike> a useful feature fails on Win32.
>> I have now changed MySQL 4.0.1 to ignore any DATA D
At 14:24 24/10/2001 +0400, Mike Blazer wrote:
Hi Mike,
Thanks for the bug report.
The explanation why the insert command doesn't works on Win32,
is because the link file pointing for the DATA DIRECTORY wasn't
created in the create table command, like the Unix version does.
The Win32
i can't find my my.cnf or data directory.
i am going nuts here...these may seem like stupid questions but i'm not even
thinking logically any more...
any help is much appreciated.
tahnks
-powlow
- Original Message -
From: "powlow" <[EMAIL PROTECTED]>
se I'm sure we'll be getting
another Email asking why it still doesn't work...)
I'm not being 'sarcastic' or 'disrespectful', it's just that it's almost 1
AM...
- Original Message -
From: "Usha Rajesh" <[EMAIL PROTECTED]>
1 - 100 of 107 matches
Mail list logo
