Hi all,
I have a database in Pervasive and I want to import it to MySQL.
I tried to convert the Pervasive data to a text file and then import it
into MySQL but it failed.
Is there any tool to do this directly?
Does MySQLCC provide any export option through which I can get the data
from Pervasive?
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysql>create table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created b
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysql>create table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created b
Hi all
where do i mention with-raid option in my.cnf file(under which
program)?
i could not find it out in the manual.
thanks in advance
prasanth
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
hi all
i am working on a very huge MyISAM table in mysql which is updated
every second. this table keeps on increasing.
so i want to store it on different disks(as one would not be
sufficient).
is there any method so that i can store the table on a different disk
once the present disk is full and
Hi all
Is there any concept of Tablespace for MyISAM tables in MySQL?
Even if it is not present, is there any concept in MySQL which is
equivalent to Tablespace in Oracle?
Where could i get the information about it?
Thanks in advance
Prasanth
-
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Do InnoDB tables support partitioning?
thanks.
Prasanth
-
Before posting, please check:
http://www.mysql.com/manual.php (the
i am new to mysql.
i have got a table tab1 in my database.
i am using 4.0.3 version of mysql and the table type is MyISAM.
the tab1 has got 14 fields and about 600,000 records and is indexed on
col1 which is of varchar type
i have used the query
select * from tab1 order by col1;
which does not us
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
but if i say
select col1 from tbl1;
it uses the index.
how to make mysql use the index on col1 for the first query?
thanks i
