the Tables to MyIsam and then after
loading, back to InnoDB but then wot abt the tables in slave...??? are
they converted to InnoDB automatically using binlog or have to be done
manually giving appropriate commands???
Thanx in advance,
Ritu Singla
Hello,
Starting mysqld with --flush, flushes tables to database or disk
log??
Thanx in advance,
Ritu Singla
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi,
try including this path i.e. /usr/lib/mysql/ in LD_LIBRARY_PATH in .cshrc
file...i guess, it'll do...
Ritu
On Fri, 7 Jun 2002, Charitha wrote:
Hello all,
I am having one application in which i am using mysql as database.
When i run my application it gives following error.
Hello,
(i had already posted this ques, got a reply but that
character format was unreadable..so i'm sorry for
posting it again..)
Starting mysqld with --flush, flushes tables to
database or disk log??
Pls. help!!
Thanx in advance,
Ritu Singla
sql,query
Hi,
Is this mysqld.log file created automatically or we need to do some
settings in my.cnf to enable this logging of mysqld?
Thanx in advance..
Ritu
On Wed, 5 Jun 2002, Eivind A. Sivertsen wrote:
You can also tail -f the logfile of mysqld...
tail -f /var/log/mysqld.log
...or
Jeremy,
do we have the control as to WHEN to update the actual
tables???
Thanx..
Ritu Singla
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu
singla wrote:
Hello,
in InnoDB tables in MySQL, if
innodb_flush_log_at_trx_commit is set to 1
Hello,
in InnoDB tables in MySQL, if
innodb_flush_log_at_trx_commit is set to 1, then on
COMMIT, the buffer log is flushed to disk log...or the
changes are reflected in the disk copy of the
database???
i mean what is flushed, the buffer-pool that contains
data and indexes or the log-buffer??
Hello!
specifying a column as unique or primary in MySQL
creates indices automatically or do we need to do it
explicitly using INDEX(unique/primary_colname) in
CREATE TABLE command of MySQL??
Thanx in advance..
Ritu Singla
u can see the InnoDB messages in 'hostname.err' file in the data dir.
On Wed, 29 May 2002, Iago Sineiro wrote:
Hi all.
Anybody knows how to see innodb messages at startup or shutdown of mysql
server?
Is there any log of messages?
Thanks in advance.
Iago.
Hello,
i could not understand what is the content of log
files in InnoDB in MySQL...is it the log of the
database,i
mean, the data, or the transaction log??
Thanx in advance..
Ritu Singla
Everything you always
Hello,
i'm running mysqld-max ver 3.23.49. When i see the
process status (ps), there are 10 processes running of
mysqld. is this fine or something wrong???
Thanks!
Ritu Singla
Everything you always wanted to know about
hello,
i'm trying to install mysql-max...using binaryver 3.23.49
i change the [mysqld] options in /etc/my.cnf as foollows to enable InnoDB
table options::
innodb_data_file_path
innodb_data_home_dir
but after changing the options, mysqld starts but ends immediately...
Pls. let me know the
they r the binary log files...
Ritu
On Tue, 14 May 2002, Augey Mikus wrote:
what are the host-bin.001 002 003 etc.. files in the mysql_dir/var
directory? On my system they range in size from bytes to gigs. What
are they and can they be cleaned?
Augey
i'm using Mysql ver. 3.23.49...
Ritu
On Fri, 10 May 2002, Jeremy Zawodny wrote:
On Fri, May 10, 2002 at 10:12:15AM +0100, ritu singla wrote:
Hi!!
I used BACKUP TABLE command to take the backup of a
table...but when i say
RESTORE TABLE, i get the following ::
mysql restore
|
rs +---+-+--+--+
rs | rs| restore | error| Failed copying .frm
rs file |
rs +---+-+--+--+
rs 1 row in set (0.00 sec)
Do you have rs.* files in /tmp dir?
rs Thanks...
rs Regards,
rs Ritu
Hi!!
I want to convert all the data in o2 database to
mysql...pls. can anyone guide me on that??
Thanx...
Regards,
Ritu Singla
For live cricket scores download Yahoo! Score Tracker
at: http://in.sports.yahoo.com
| Op | Msg_type | Msg_text |
+--++--+--+
| ritu.abc | backup | status | OK |
+--++--+--+
1 row in set (0.00 sec)
Pls. tell me where i went wrongi locked the table
before backup...
Thanks...
Regards,
Ritu Singla
Hi!!
I used BACKUP TABLE command to take the backup of a table...but when i say
RESTORE TABLE, i get the following ::
mysql restore table rs from '/tmp';
+---+-+--+--+
| Table | Op | Msg_type | Msg_text |
Hi!!
try this ::
gcc -I/usr/local/mysql/include custom1.cc
-I is used to specify the path of include files
Regards,
Ritu
On Mon, 29 Apr 2002, adelpfe wrote:
hi every body
i have installed mysql++ for linux. when i try to compile examples , i
get this message:
gcc custom1.cc
i
In fact, i'm trying to read data from a binary file and want to insert
that into the database. I guess, it would be easier and more efficient if
i use some data structure like we have vectors in C++ API.
Thanks,
Ritu Singla
On Thu, 18 Apr 2002, Robert Cross wrote:
you wrote:
I want
Hi!!
I want to know if there is any datatype in MySQL C API which is similar to
a structure in C???
Thanks,
Ritu Singla
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
as early as possible...
Thanking You in anticipation...
Ritu Singla
Research Engineer,
C-DOT,
New Delhi.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hello,
I read the MySQL Reference Manual for version
3.23.49. I tried some C API's, but was stuck up trying
to insert data from a file into the MySQL database.
Please help me out as i could not find any material on
FILE HANDLING in MySQL C API.
Thanking You in anticipation...
Ritu
23 matches
Mail list logo
