newbie question

2005-02-22 Thread jsf
This may be more of a PHP question than a MySQL question but here goes: I have a small database with two tables in it. It's a database of Botanical Gardens in the US. Table 1 contains the botanical gardens and has 8 fields: (I'm abbreviating for brevity and clarity): id, name, address, town, s

BIG INNODB Problems solved.. I think

2005-01-07 Thread jsf
A few days ago I did the following: Turned off MySQL. Installed 4.1.8a, then I went into the directory where all of the database files are located. I moved everything having to do with INNODB tables and logs into another location for safekeeping. Then I started up the new version of MySQL. I

Re: BIG InnoDB problems!

2005-01-03 Thread jsf
InnoDB database: > http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html > > Be very careful. You do not want to lose your valuable data. > > Regards, > > Heikki > > - Alkuperäinen viesti - > Lähettäjä: "jsf" <[EMAIL PROTECTED]> > Vastaa

Re: BIG InnoDB problems!

2005-01-03 Thread jsf
backs up MyISAM > tables > http://www.innodb.com/order.php > > Order MySQL support from http://www.mysql.com/support/index.html > > - Alkuperäinen viesti - > Lähettäjä: "jsf" <[EMAIL PROTECTED]> > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>

Re: BIG InnoDB problems!

2004-12-31 Thread jsf
gt; Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > http://www.innodb.com/order.php > > Order MySQL technical support from https://order.mysql.com/ > >

Re: BIG InnoDB problems!

2004-12-30 Thread jsf
mysql.com/doc/mysql/en/Forcing_recovery.html > > On Thu, 30 Dec 2004 17:21:40 -0500, jsf <[EMAIL PROTECTED]> wrote: > > I've been struggling with this problem for the last few days. I've > > enlisted the help of some colleagues on the NYLUG (NY Linux User's >

BIG InnoDB problems!

2004-12-30 Thread jsf
I've been struggling with this problem for the last few days. I've enlisted the help of some colleagues on the NYLUG (NY Linux User's Group) list but finally we figured this is the best place to look for some help. We have a server running SLES 9.0 (SuSE Linux Enterprise Server 9.0) and: mysqlad