List:General Discussion« Previous MessageNext Message »
From:Heikki Tuuri Date:March 12 2001 4:32pm
Subject:Re: Innobase in MySQL
View as plain text  
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:  mehalick@stripped 
>-----------------------------------------
>
>
>

Thread
Re: Innobase in MySQLHeikki Tuuri12 Mar
  • Re: Innobase in MySQLJoshua J. Kugler12 Mar
RE: Innobase in MySQLHeikki Tuuri12 Mar
RE: Innobase in MySQLHeikki Tuuri12 Mar
Re: Innobase in MySQLHeikki Tuuri12 Mar
  • Re[2]: Innobase in MySQLPeter Zaitsev13 Mar
    • Re: Innobase in MySQLDan Nelson13 Mar
      • Re[2]: Innobase in MySQLPeter Zaitsev14 Mar
        • Re[2]: Innobase in MySQLMichael Widenius14 Mar
          • Re[3]: Innobase in MySQLPeter Zaitsev16 Mar
            • Re[3]: Innobase in MySQLMichael Widenius16 Mar
    • Re: Re[2]: Innobase in MySQLWilliam R. Mussatto13 Mar
  • Re: Innobase in MySQLGreg Cope17 Mar
    • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
  • Re: Innobase in MySQLGreg Cope18 Mar
    • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
Re: Innobase in MySQLAndreas Vierengel17 Mar
  • Re[2]: Innobase in MySQLPeter Zaitsev18 Mar
Re: Innobase in MySQLHeikki Tuuri17 Mar
Re: Innobase in MySQLAndreas Vierengel18 Mar
Re: Re[2]: Innobase in MySQLAndreas Vierengel18 Mar