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 MyISAM
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
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 <h.rei...@thelounge.net>
wrote:
>
>
> Am 13.11.2015 um
[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 meant
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
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
packages 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
he 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,
>>
>
: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
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
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 ls -lha
the data directory
to a directory called /var/lib/db/mysql. I changed the datadir variable in the
my.cnf file to point to this directory. This was to be sure that our data
directory was not on the same partition as our SYSTEM or the Log partitions.
Everything is working fine except I have the files
.sequence number. 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 called
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 /media/disk
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
and copy all data to the new directory
2009/8/26 chen jia 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 of MySQL.
After stopping MySQL: sudo /etc/init.d
-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 /media/disk/MySQL_data
then change the ownership of new directory, sudo chown mysql:mysql
/media/disk
/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 /media/disk/MySQL_data
then change the ownership of new directory, sudo chown
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
and copy all data to the new directory, cp -r -p
-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
and copy all data
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
and copy all data to the new directory, cp
back to the
original one, I can start MySQL successfully.
I think I have done everything needed to change MySQL data
directory.
Why am I still getting this error? Where can I start to look
for the causes?
Thanks.
Jia
--
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
-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
and copy all data to the new
should produce good results.
On Tuesday, August 25, 2009, chen jia chen.1...@gmail.com 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
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 for you
http
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 my.cnf
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 running in Linux
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
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 owner
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 not support Unix file
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
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
.
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 nobody has thought about doing that
before. At least I don'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 wrote:
Specify the data dir
---
-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
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 MySQL
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 to
a non-standard
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 move
the datadir
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
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
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 main problems
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) under the [mysqld
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
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 create
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]
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 file
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
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 the location of the data
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 how to change
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
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/mysql/mysql.sock
# Default to using old password
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 all my other data and
programs. Originally this was set up under a Debian-based
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 all my other data
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
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 tables
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
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
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:
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
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:21 PM
To: [EMAIL PROTECTED]
Subject: Changing Data Directory
Hi all
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 switch
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't
seem to work
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 switch of --datadir
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
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
/var1/lib/mysql instead of /var/lib
]
Subject: how to change default data directory
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
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:
I am using RH7.1 box . I am preparing
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 default data directory
Hi Sanjay,
I see two ways
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 I achieve any better
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 the
Data Directory.
My application has lots
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%) and fewer
UPDATEs/INSERTs(20 %).
I have
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 the
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
]
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 process of setting up a new Red Hat 8 box and I
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 as:
[mysqld
_
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: data directory in 4.0.9
Where
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)
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 initialize InnoDB as 'innodb_data_file_path
data directory:
JS kaaawa# mv data data.orig
JS started up again:
JS kaaawa# bin/safe_mysqld --user=mysql
JS [1] 963
JS kaaawa# The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
JS Please do a cd to the mysql installation directory and restart
JS this script from
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 work.
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
hide the installed data directory:
kaaawa# mv data data.orig
started up again:
kaaawa# bin/safe_mysqld --user=mysql
[1] 963
kaaawa
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.
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 directory,
DC create
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 do I
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] wrote
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
and 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
Hi!
Mike == Mike Blazer [EMAIL PROTECTED] writes:
cut
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 DIRECTORY
directives, until we have come up with an acceptable
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 symbolic link support on Win32 is made creating a plain text
file with the extension *.sym on \data directory and contains the
path of the whole
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 OSs don't
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]
To: Sasha Pachev [EMAIL PROTECTED
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]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 12:15 PM
Subject: data directory.
Hi
I don't have any idea why its happening like that.
When I run the command /usr/local/mysql/bin/safe_mysqld, it says mysqld
ended.so, I want to check the hostname.err under the data
directorybut the data dir itself is missing here...
Someone please tell me what is the problem
1 - 100 of 104 matches
Mail list logo
