owing:
- create table
- check INNODDB status and copy the table.ibd to a new location
- run ALTER TABLE table DISCARD TABLESPACE
- symlink the table.ibd copy within the database folder
- run ALTER TABLE table IMPORT TABLESPACE
- run show table status like 'table';
And here are the crash d
If Linux works the same way as HP-UX (and it should), anything you do to an
open file (including deleting it) has no effect until the file is closed. The
MySQL server is still using the "old" file. The next time it stops and
restarts, it will follow the symlink. I don't know wha
lev schrieb:
> > Hi,
> > What I'm trying to do is to create a new InnoDB table on a different disk
> > and symlink it to an existing database.
> > I have innodb_file_per_table turned on and here is how I tried to do it
> >
> >
> > mysql> \u test
Dobromir Velev schrieb:
Hi,
What I'm trying to do is to create a new InnoDB table on a different disk and
symlink it to an existing database.
I have innodb_file_per_table turned on and here is how I tried to do it
mysql> \u test
mysql> create table test (...) ENGINE = 'I
Hi,
What I'm trying to do is to create a new InnoDB table on a different disk and
symlink it to an existing database.
I have innodb_file_per_table turned on and here is how I tried to do it
mysql> \u test
mysql> create table test (...) ENGINE = 'InnoDB';
mysql>\q
move
; Hi Andy,
>
> I see that. Unfortunately, I have no idea why mysql is trying to create
> a symlink to a symlink it just created. Does anyone have any idea why
> mysql would do that?
>
> Thanks,
>
> Mark
>
>
> Ady Wicaksono wrote:
>
>> H
Hi Andy,
I see that. Unfortunately, I have no idea why mysql is trying to create
a symlink to a symlink it just created. Does anyone have any idea why
mysql would do that?
Thanks,
Mark
Ady Wicaksono wrote:
Hi Mark,
There's perror to check what happen, so when you have Error 17 you
check
to add an index to a
set tables that make up a merge table. Here is a transcript of the
session:
mysql> alter table he_access_offline_3 add index status (status);
ERROR 25 (HY000): Can't create symlink './Logs/#sql-156e_48d8.MYI'
pointing at '/var/lib/mysql/Logs/#sq
Hi all,
I've been getting a strange error when attempting to add an index to a
set tables that make up a merge table. Here is a transcript of the session:
mysql> alter table he_access_offline_3 add index status (status);
ERROR 25 (HY000): Can't create symlink './Logs/
Hello.
What is in error log? Usually it is located in the data directory or
in the place which was specified in config file. More information you
may find at:
http://dev.mysql.com/doc/mysql/en/Symbolic_links.html
"kaustubh shinde" <[EMAIL PROTECTED]> wrote:
> Hi all
> I recently instal
Hi all
I recently installed SUSE linux and I am running MySQL 4.0.21
The way system is configured, /var ran out of disk space.
I have RAID installed and /data is on raid. So I created a new folder mysql
in /data
and copied all the files from /var/lib/mysql to this folder. I renamed
/var/lib/mysql
Hi,
Is there any way to create a symlink of table in two different databases which
belongs to the same user.
It will be great help if I get the solution for above mention task.
Regards,
Haq
t it to be changed in
Linux's DBs when I reboot, and vice versa.
I am not completely satisfied with the solution I've done - I've
created a symlink from linux's data directory to the mounted fat32
system where the win's data dir is located. It works as planne
13 matches
Mail list logo
