Restore from XML file

Hi All, Is it possible to restore the database from an XML file ( generated from mysqldump -X)? Please provide me the syntax. (mysql database xmlbackupfile is not working ). But restore is working fine with the normal backup file. Please throw some light on it. Thanks

Transactions in MySQL.

Hi All, How transactions and locking are handled in MYSQL? Is it a part of configuration? Or a query (lock tables, Unlock tables) for each set of queries? Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended

How to delete all rows....

Hi All, How do I delete all the rows of all the tables(but not table) in the database at one shot. Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may

MYSQL on GHS Integrity..

Hi All, Anybody know how to install Mysql on GHS Integrity RTOS. Where I will get the mysql package for the same. Or can I use the same as for Linux. Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended for

How to make this work ?

Hi All, How to make this work CREATE TABLE DB2.tblname LIKE DB1.tblname; Can we have simultaneous connections with 2 DBs? Regards, Ravi K The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the

RE: Can a table be copied across the DBs?

Hi All, As per the below query, can we have simultaneous connection with two DBS and refer both the DBs in the same query? Like CREATE TABLE DB2.tblname LIKE DB1.tblname. Regards, Ravi K -Original Message- From: Dominik Klein [mailto:[EMAIL PROTECTED] Sent: Friday, August

Can a table be copied across the DBs?

Hi All, I want to copy a table (along with its contents) from one database to another database. In the destination database the table doesn't exist. Please let me know, if there is any way to do it. Regards, Ravi K The information contained in this electronic message and

structure of whole table...

THANKS ALL for the tremendous response. It is really helping me a lot I have another query. Can the output of the DESCRIBE be stored somewhere ( in file)? I suppose the DESCRIBE query doesn't return the result set. Or is there any way to get the structure of whole table? Regards,

Can a row be refered using row number?

Hi All, Is there any way to refer a row based on the row number or row count? I just the effect as below... E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4 Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5 Regards, Ravi K The information contained in this

MySQL App development

Hi All, I need to develop an utility in C++ (don't want to use mysql++ lib) which provides services to other modules in the system like createTable( ), createRow( ), updateAttr( ) Etc. wherein these APIs are called dynamically by the other modules to do the DB operations. Is

MySQL for integrity RTOS

Hi All, I am a new to this mailing list. Also to Mysql. Anybody knows how mysql is installed and used in Integrity RTOS. Plz fwd if any docs are available. Thanks, Regards, Ravi K The information contained in this electronic message and any attachments to this message are