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
Здравствуйте, 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
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
Здравствуйте, 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
Здравствуйте, 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.
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?
-
Здравствуйте, Экономиcт.
Вы писали 8 октября 2006 г., 5:37:00:
>> АНАЛИЗ ВЗАИМОСВЯЗИ РАСХОДОВ, ОБЪЕМА ДЕЯТЕЛЬНОСТИ И ПРИБЫЛИ (CVP-АНАЛИЗ).
>> АНАЛИЗ РЕЛЕВАНТНОЙ ИНФОРМАЦИИ ДЛЯ ПРИНЯТИЯ УПРАВЛЕНЧЕСКИХ РЕШЕНИЙ.
>> ЦЕЛЕВОЕ ПЛАНИРОВАНИЕ ПРИБЫЛИ.
>> Тренинг • 13 октября • 2006 г.
>> г. Kиeв • ул
Здравствуйте, .
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),
Здравствуйте, Гордеев.
Вы писали 20 августа 2006 г., 12:58:35:
> Здравствуйте!
> Интересует такой момент. Мой сайт хостится у местного провайдера. Они
> создали
> базу mySQL где у меня и лежат таблицы для моего портала. Возникла
> необходимость
> перенести модули (гостевая книга и фотога
Здравствуйте, 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
Çäðàâñòâóéòå, 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
Здравствуйте, 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
Здравствуйте, 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
Здравствуйте, 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
Здравствуйте, .
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
Здравствуйте, 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
Здравствуйте, 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
--
С
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
18 matches
Mail list logo