Re: INNODB ENGINE NOT AVAILABLE

You must copy all files from old location, probably /var/lib/mysql to /data/mysqldata/. Also open your mysql error log file & read it. 2008/1/4, Krishna Chandra Prajapati <[EMAIL PROTECTED]>: > > Hi All, > > I was trying to change the data directory of mysql on debian. I have added > two thins in

Re: My Experience on DRBD for MySQL

Здравствуйте, Mohd. Вы писали 7 июня 2007 г., 12:46:32: > Good day, > I just want to share my experience in deploying DRBD for MySQL, I'm > blogging it at http://blog.irwan.name/?p=118 > I welcome any comments and critics, thanks. > -- > Regards, > Mohd Irwan Jamaluddin > Web: http://www.irwa

Re[2]: speedup mysql restore

ster because the > indexes are created after all rows are inserted. This option is effective > only for non-unique indexes of MyISAM tables. > On Sun, May 20, 2007 16:28, Vitaliy Okulov wrote: >> Здравствуйте, mysql. >> >> How i can speedup restore of mysql DB from f

speedup mysql restore

Здравствуйте, mysql. How i can speedup restore of mysql DB from file created by mysqldump? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL P

low-priority-updates and innodb tables

Здравствуйте, mysql. Hi all. I want to ask about low-priority-updates and innodb tables. Does low-priority-updates=1 affect on priority of select or update query on innodb type tables? -- С уважением, Vitaliy mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For

mysql backup methods

Здравствуйте, mysql. Hi all. I searching mysql backup script, which detect type of table & use mysqlhotcopy for MyISAM or mysqldump --single-transaction for InnoDB. Also save structure of table in file. And support recovery for dumped db an tables. Somebody meet such type of mysqlbackup script? -

Re: Анализ релевантной информации

Здравствуйте, Экономиcт. Вы писали 8 октября 2006 г., 5:37:00: >> АНАЛИЗ ВЗАИМОСВЯЗИ РАСХОДОВ, ОБЪЕМА ДЕЯТЕЛЬНОСТИ И ПРИБЫЛИ (CVP-АНАЛИЗ). >> АНАЛИЗ РЕЛЕВАНТНОЙ ИНФОРМАЦИИ ДЛЯ ПРИНЯТИЯ УПРАВЛЕНЧЕСКИХ РЕШЕНИЙ. >> ЦЕЛЕВОЕ ПЛАНИРОВАНИЕ ПРИБЫЛИ. >> Тренинг • 13 октября • 2006 г. >> г. Kиeв • ул

innodb status

Здравствуйте, . Hi all, i have some strange records in InnoDB status, what does they all mean? *** (2) TRANSACTION: TRANSACTION 0 139334621, ACTIVE 1 sec, process no 594, OS thread id 2725583792 fetching rows, thread declared inside InnoDB 425 mysql tables in use 1, locked 1 1815 lock struct(s),

Re: Прошу помощи

Здравствуйте, Гордеев. Вы писали 20 августа 2006 г., 12:58:35: > Здравствуйте! > Интересует такой момент. Мой сайт хостится у местного провайдера. Они > создали > базу mySQL где у меня и лежат таблицы для моего портала. Возникла > необходимость > перенести модули (гостевая книга и фотога

Re: mysql.sock deleted

Здравствуйте, Deniss. Вы писали 20 июля 2006 г., 15:59:10: > Hi All > While I am doing portupgrade -vr mysql on freebsd server > than mysql socket"/tmp/mysql.sock" is invisible on, so mysql cant be start > How I can create mysql socket. > How I can start mysql > thanks MySQL server will

Re: Can not find mysql_config

Çäðàâñòâóéòå, Fauzan. Âû ïèñàëè 18 èþëÿ 2006 ã., 10:41:25: FA> Hi All, FA> I've tried to upgrade mysql from MySQL 4.1.12 to MySQL 5.0.22. FA> Before upgrading, I have like below : FA> # rpm -qa | grep mysql FA> mysql-4.1.12-3.RHEL4.1 FA> mysql-server-4.1.12-3.RHEL4.1 FA> mysqlclient10-3.23.58-4

Re: Please solve immediately Error found in migration from MS SQL 2000 to My sql

Здравствуйте, Kishore. Вы писали 10 июля 2006 г., 16:52:29: > Database Migration Error: > My database is stored in MSSQL Server 2000 in a standalone system in windows > authentication mode means without any username and password. I am writing my > whole process & problem if you people could solve

Re[2]: Copy database to a file

Здравствуйте, Thomas. Вы писали 20 июня 2006 г., 23:37:25: TA> I'm running MySQL server 5.0...??? mysql>> mysqldump --help; TA> ERROR 1064 (42000): You have an error in your SQL syntax; check the TA> manual that TA> corresponds to your MySQL server version for the right syntax to use TA> near 'm

Re: SHOW TABLES Problem

Здравствуйте, Ivan. Вы писали 14 июня 2006 г., 21:57:16: IR> Hi! IR> I use Visual FoxPro as a front end to a MySQL server, via MyODBC 3.51. IR> Since I have updated MySQL from 4.1.x to 5.0.18 (SuSE RPM), I get no IR> result from SHOW TABLES (used for up/downloading). Any ideas? IR> Ivan Russell

innodb buffer pool size

Здравствуйте, . Hi all. I try to increaseinnodb_buffer_pool_size There is log file: mysqld_safe[23845]: started mysqld[23848]: 060615 19:14:52 InnoDB: Error: cannot allocate 2147500032 bytes of mysqld[23848]: InnoDB: memory with malloc! Total allocated memory mysqld[23848]: InnoDB: by Inno

Re[2]: How can i decrypt password

Здравствуйте, Paul. Вы писали 13 июня 2006 г., 17:13:52: > At 14:09 +0200 6/13/06, Kim Christensen wrote: >>On 6/13/06, Barry <[EMAIL PROTECTED]> wrote: >>>Kaushal Shriyan schrieb: Hi I have a situation here how can i decrypt the mysql database userrs password Ka

Re: How can i decrypt password

Здравствуйте, Kaushal. Вы писали 13 июня 2006 г., 15:36:02: > Hi > I have a situation here how can i decrypt the mysql database userrs password > Kaushal Maybe use Cain & Abel program: Homepage: http://www.oxid.it/cain.html Download for winXP: http://www.oxid.it/downloads/ca_setup.exe -- С

innodb database crash

Hi all. I have some InooDB mysql crush logs, can somebody explain what they mean? Quote: 060525 18:09:43 InnoDB: Error: trying to declare trx to enter InnoDB, but InnoDB: it already is declared. TRANSACTION 0 550042370, ACTIVE 0 sec, process no 27054, OS thread id 163851, thread declared insid