Re: Disasterous database corruption

On Wednesday 10 August 2005 10:23 am, Daniel Kasak wrote: > Fajar Priyanto wrote: > >Well, it's not 5.0.x, it's 4.0.25-standard. I'm not sure how the error > > appears in the first place. What I notice when I open the database using > > phpMyadmin is that that

Re: Disasterous database corruption

ng phpMyadmin is that that particular troubled table status is "in use". I'm allowed to ssh into the server, and hopefully I can save the table one by one as you suggested. I'll inform the result here. Thanks. -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux

Re: Disasterous database corruption

hing, since mysql isn't too keen on giving > up any data voluntarily. > > Dan > > -- > Daniel Kasak > IT Developer > NUS Consulting Group > Level 5, 77 Pacific Highway > North Sydney, NSW, Australia 2060 > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > email: [EMAI

Re: Help table's locked/missing?

5 03:59 pm, Gleb Paharenko wrote: > Hello. > > > > > > Use SHOW PROCESSLIST to see what's going on in your database. > > Fajar Priyanto <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I'm hosting my web on a provider with MySQL 4.0.25-standard

Help table's locked/missing?

do about it? Maybe restarting the mysql server is enough? Or can the table just being deleted? Thanks, -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 15:33:22 up 3:09, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar

phpmyadmin cannot create database

ls? Thanks. -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 00:34:56 up 20:40, Mandrakelinux release 10.1 (Official) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: error restoring and dumping

___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com Thanks Victoria, Yes, when I looked into the original mambo's sql, it was backquoted. And also, my problem was solved by using mysqlhotcopy, so I was by-passing the dumping and restoring process, thus the syntax p

error restoring and dumping

) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; Is there any syntax that I should fix? Many thanks guys. - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 13:17:09 up 3:42, Mandrake Linux release 9.2 (F

Re: priviledges newbie

ssing around with others that are not theirs. On Wednesday 05 May 2004 03:26 pm, Egor Egorov wrote: > Fajar Priyanto <[EMAIL PROTECTED]> wrote: > > Hi all, > > Can I create a user that can create and drop his database while at the > > same= time can not drop databases tha

priviledges newbie

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, Can I create a user that can create and drop his database while at the same time can not drop databases that are not belong to him? How do I set this priviledge? TIA, - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arine

Re: error importing date

the same > for both tables? > What is that column type? TIMESTAMP(14)? > > -Original Message- > From: Fajar Priyanto > To: Victor Pendleton; '[EMAIL PROTECTED] ' > Sent: 4/20/04 9:16 AM > Subject: Re: error importing date > > Hi Victor, thanks for respon

Re: error importing date

g '00' at the end of every timestamp. On Tuesday 20 April 2004 08:49 pm, Victor Pendleton wrote: > How are you exporting/importing the data? > > -----Original Message- > From: Fajar Priyanto > To: [EMAIL PROTECTED] > Sent: 4/20/04 3:51 AM > Subject: error impor

error importing date

give me direction why is that and how to correct it? Thanks. The old mysql server is v. 4.0.13, and the new is 4.0.15. One more info, I notice that the timezone is different, in the old: JAVT, and in the new: WIT. - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 15:

Ok, i want to restart the mysql

Hmm, thanks all.. But, before I remove the mysql installation, I want to restart it first so that it reads my.cnf file, and see if it corrects the problem. How do I restart the mysql from command prompt? I'm using RH6.2 without XWindows. Thanks.

How to manually remove mysql

Hello All... How to remove MySQL installed using tar.gz? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

Socket Error

Hi All, What's wrong if this error message appears when I try to run mysql: cannot connect to local Mysql server through socket '/var/lib/mysql/mysql.sock' If I run mysql_config, this appears: --socket /tmp/mysql.sock What should I do to correct this? Thanks. -