Rick,
>I wasn't sure if I should email to the mysql list or directly to you. Here
maybe it is best both to post to the mailing list and send a carbon copy
directly to me, so that others can share the advice.
>are my questions about the Innobase tables:
>
>1) Do you have to start a transaction before a select, or does AUTOCOMMIT
>still work as it does with BDB and GEMINI?
Autocommit commits your work after each SQL statement. You do not
need to start a transaction explicitly. If you set autocommit=0
in MySQL, then after each commit, Innobase automatically starts
a new transaction when the next SQL statement arrives to be processed.
>2) Can you perform backups as with other tables?
You have to shut down the database, make sure that it shuts down without
errors, and then copy the Innobase data files to a safe place (it is
safest also to copy the log files). Note that the .frm files only contain
table definitions, not table data, which resides in the data files you specify
in my.cnf. Currently there is no incremental backup nor on-line backup
in Innobase.
>3) If I have BDB tables now, how can I get the data into Innobase tables?
You can use the ALTER TABLE statement:
ALTER TABLE yourtable TYPE=INNOBASE;
Regards,
Heikki
>Thanks,
>Rick
>
>-----------------------------------------
>/ Rick Mehalick Senior Consultant
>/ Shell Services International SSI-GPAX
>/ Phone: 281-544-5092(WCK)
>/ Fax: 281-544-2646(WCK)
>/ email: [EMAIL PROTECTED]
>-----------------------------------------
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
