Re: Restoring database with frm myi and myd

The db format is in "innodb" On Dec 17, 2007 5:38 PM, To Glace <[EMAIL PROTECTED]> wrote: > Hello, > > A database which has been deleted need to be restored. > There is no .sql dump file. > All we have is the .frm, .myi and .myd files from > /var/lib/mysql/DATA

Restoring database with frm myi and myd

Hello, A database which has been deleted need to be restored. There is no .sql dump file. All we have is the .frm, .myi and .myd files from /var/lib/mysql/DATABASENAME. Here are the steps I have taken: 1. Created a new empty database - NEWDB 2. individually restored all tables using the restore

Problems with clean NET STOP MYSQL on Win2000 server after adding INNODB space

Help! We're running MySQl on Win2000 server. The other day our INNODB database filled up, so we stopped the server, backed up the data, and adjusted the innodb_data_file_path from ibdata1:500M;ibdata2:500M;ibdata3:500M; to ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M;

multiple databases: design question

cross multiple DBs (on one server) to all tables in one DB (on one server.) I don't want to do this, but may need to given the constraints of perl's Class::DBI and Ima::DBI. Specifically, I am stuck on successfully handling transactions and rollback across multiple databases, because Ima

nested transactions

Does INNODB support nested transactions? If so, what version? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

txns with INNDOB

Hi -- I am trying to understand txns under INNODB. I'm running 4.0.16-nt-log. Here's my test code, all run in one MySQLYog window. -- step 1 use scratch; -- drop table foo; -- create table foo (x int); truncate table scratch.foo; -- step 2 use scratch; set autocommit=1; -- st

reset auto_increment

I need to reset the auto_increment in a table full of data. I had a problem recently where some script was putting InvoiceID numbers into an auto_increment CustID column...I since fixed the problem and corrected the data but I now have a huge gap in my number sequence and I cant get

Re: MySQL 4.0.7 is released

In article <[EMAIL PROTECTED]>, Andreas <[EMAIL PROTECTED]> wrote: >Hsiao Ketung Contr 61 CS/SCBN wrote: > >> Who would have the need to use src version of installation. >> I imagine that src version give user more options for customizing MySql. > >sure ...

Blob accepts LongBlob without error

of the BLOB data-type and it will still accept it. Perhaps MySQL should output an error or at least a warning to know the string is too long. Thanks much, -Ryan Hatch - Before posting, please check: http://www.mysql.com

Missing mysql_install_db on Windows binary distribution

I'm totally new to mysql so I may be asking a real dumb question here. Does anyone know whether the running of mysql_install_db necessary for the Windows distribution of mysql? I downloaded the binary mysql-3.23.43-win.zip file yesterday and ran the setup. However, there i

error 2013 and 2002 when i install the mysql database

Dear Sir, My Linux is RedHat Linux 6.0 I follow the below step to install the mysql version 3.23.37 database : 1. tar ¡Vzxvf mysql-3.23.37.tar.gz 2. ./configure ¡Vprefix/usr/local/mysql 3. make 4. make install 5. echo ¡§/usr/local/mysql/lib/mysql¡¨ >> /etc/ld.so.

have a great problem to install the mysql database

Dear Sir, I have a great problem to install the mysql database. I follow the instruction at the below : 1. tar -xvzf mysql-3.23.37.tar.gz 2. ./configure ¡Vprefix=/usr/local/mysql 3. make 4. make install 5. echo "/usr/local/mysql/lib/mysql" >> /