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 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. That actually sounds nothing like the problem I'm having. I'm not getting any 'in use' errors. Perhaps you have a different issue? I'm not sure, but the symptom is similar to yours. Apparently the command SHOW doesn't work. And now, using SELECT from phpMyadmin I'm manually dumping every table. Luckily, I have a backup of last month database so I can follow the name of 56 tables. Thanks. -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 13:58:10 up 1:57, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help table's locked/missing?
Hi Gleb, This is what I have using SHOW PROCESSLIST: Waiting for tableSHOW TABLE STATUS FROM `db_mambo` LIKE 'mos_TFS_visits' Help me pls, is there any way I can save this database? Looks like the troubled table is mos_TFS_visits. Thanks, Fakar On Monday 08 August 2005 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. I've got this situation when I open my database using phpMyadmin, one of my table has status is in use. And then when I try to repair the database, MySQL just hung there while consumed around 50% of CPU. And then when I tried to export the database, phpMyadmin got stuck at that tables, with a status of SHOW TABLE STATUS FROM 'thetroubledtable'. I tried to contact the hosting provider, but it seems they're having weekend break. Is there any way that I or my hosting provider can do about it? Maybe restarting the mysql server is enough? Or can the table just being deleted? Thanks, -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 23:51:20 up 25 min, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Disasterous database corruption
This is what I think hit me too, Daniel. Unfortunately, it's not on my own server (a hosting provider), so my access to the shell is very limited. My website is still running, but, I can't export the database using phpMyadmin anymore, because the troubled table is on the first list of tables. Do you have any idea on how to save my other tables? Thanks. Fajar On Tuesday 09 August 2005 08:16 am, Daniel Kasak wrote: Hi all. I've been testing out mysql-5.0.10 on my Powerbook ( Gentoo Linux PPC ), and I've hit an incredibly unfortunate bug. It is demonstrated adequately with the following: mysql use entropy; Database changed mysql show tables; ERROR 1052 (23000): Column 'TABLE_NAME' in order clause is ambiguous mysql quit Bye [EMAIL PROTECTED] ~ $ mysqldump -u root --opt --all-databases full_dump.sql -p Enter password: mysqldump: mysqldump: Couldn't execute 'SHOW DATABASES': Column 'SCHEMA_NAME' in field list is ambiguous (1052) [EMAIL PROTECTED] ~ $ I can't get anything out of the DB with any GUI tools. I assume they all want to inspect the tables and bail out when they hit something like the above. The data is still there, and I can select from tables that I already know the name of ( which, luckily, I do ... for the important stuff ). So I suppose I don't *really* need any help in backing stuff up - I can back up table by table to text files and then re-import. Is anyone interested in examining what went wrong? ie should I create a bug report? I suppose I'd have to upload a zipped copy of my /var/lib/mysql folder or something, 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: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 00:25:04 up 59 min, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Disasterous database corruption
On Wednesday 10 August 2005 06:50 am, Daniel Kasak wrote: A hosting provider running 5.0.x? That's whacky. When you say my access to the shell is very limited, what does that mean exactly? Can you ssh in and run the 'mysql' command-line client? If you can, then do it, and you should be able to 'select * from table_name' for all the tables in your database(s). Note that 'show databases' and 'show tables' will not work, so you have to know these already :) You can use the 'tee' option to output stuff to a file. I've entered a bug report at: http://bugs.mysql.com/bug.php?id=12475 Good luck :) 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 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://linux2.arinet.org 10:03:25 up 35 min, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help table's locked/missing?
Hi all, I'm hosting my web on a provider with MySQL 4.0.25-standard. I've got this situation when I open my database using phpMyadmin, one of my table has status is in use. And then when I try to repair the database, MySQL just hung there while consumed around 50% of CPU. And then when I tried to export the database, phpMyadmin got stuck at that tables, with a status of SHOW TABLE STATUS FROM 'thetroubledtable'. I tried to contact the hosting provider, but it seems they're having weekend break. Is there any way that I or my hosting provider can 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-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin cannot create database
Hi folks, I'm trying phpmyadmin 2.6.0-pl3 with mysql 4.0.15 I notice that when I setup and use the pma user in the config, I cannot create database even when I login with root (using cookie auth). But if I don't use the pma options, I can create database. Can you shed a light on me pls? 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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error restoring and dumping
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm trying to move my Mambo (content management) database from one server into another. In the old server, the mysql version is 4.0.13, while in the new one it's 4.0.15. The error was when restoring: ERROR 1064 at line 141: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'option varchar(50) DEFAULT '' NOT NULL, ordering int(11) unsi These are the corresponding lines: # # Table structure for table `mos_components` # CREATE TABLE mos_components ( id int(11) NOT NULL auto_increment, name varchar(50) NOT NULL default '', link varchar(255) NOT NULL default '', menuid int(11) unsigned NOT NULL default '0', parent int(11) unsigned NOT NULL default '0', admin_menu_link varchar(255) NOT NULL default '', admin_menu_alt varchar(255) NOT NULL default '', option varchar(50) NOT NULL default '', ordering int(11) unsigned NOT NULL default '0', admin_menu_img varchar(255) NOT NULL default '', iscore tinyint(4) 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 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAtYjUkp5CsIXuxqURAi6MAJ4plW4vNtCUYx8pS3AzxrT3PhyhqQCeJt70 Dcs7iJI17bx1vnMlxjnv90I= =p7vr -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error restoring and dumping
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 27 May 2004 02:56 pm, Victoria Reznichenko wrote: OPTION is a reserved word in MySQL: http://dev.mysql.com/doc/mysql/en/Reserved_words.html Use backticks to quote column names: `option`. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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 problem. Thanks again. - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 15:51:05 up 6:16, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAtayykp5CsIXuxqURAleMAJ9kMpq9DbN5MCmh206tZtfk0qOLIQCgtF+b iiXb2cjfTA64VNeaXWa0DZo= =whxM -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: priviledges newbie
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks Egor, It works. But it seems that it's not 100% automatically just like unix file permission. The administrator must set it up on each database. So, I give the users CREATE privilege globally, but not DROP. It will prevent them from messing 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 that are not belong to him? How do I set this priviledge? If you grant CREATE and DROP privileges on the dbname, it means that user can only create and drop database with name 'dbname'. GRANT CREATE, DROP ON dbname.* TO 'user'@'hostname' IDENTIFIED BY 'userpassword'; http://dev.mysql.com/doc/mysql/en/Privileges_provided.html http://dev.mysql.com/doc/mysql/en/GRANT.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 16:56:48 up 8:52, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAmLrkkp5CsIXuxqURArGsAJ9EXtAkkQ4ljdpyMMoU3rVam/iSlwCfbEIs WVJxZ/nvO8agp6jwj1KNq8g= =2pYJ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.arinet.org 09:01:15 up 56 min, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAmE12kp5CsIXuxqURAvJ6AJsEzsyjYwb42RJztTkxese1+AMifACaAtZm 2fVGYvRxTcNr7SB1dlbP1Tg= =mEKb -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error importing date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I encounter this error when importing database from one mysql server into another: the date imported is wrong. The type is timestamp. In the dump file, the date is : 0404121921, but when imported, it becomes: 0004041219. Could anybody pls 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:47:50 up 7:38, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAhOR7kp5CsIXuxqURAqwWAJ9+rrT8JtL5418kjNfFfb92lPU5PACghTvC yirB75rqkc1vrPMtD0pos9U= =eosZ -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error importing date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Victor, thanks for responding. I really need help here. I export/import the database using mysqldump (for exporting), and the mysql command (for importing). One thing to be noted thought, the exported sql has correct timestamps (they're exactly the same when in still the database). Also, I found another interesting thing: When I modified the timestamps in the dumpfile, adding '00' at the end, example: from 0404121921 into 040412912100, it got imported correctly. What gives? I'm thinking of hacking the dumpfile adding '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 importing date Hi all, I encounter this error when importing database from one mysql server into another: the date imported is wrong. The type is timestamp. In the dump file, the date is : 0404121921, but when imported, it becomes: 0004041219. Could anybody pls 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:47:50 up 7:38, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 21:11:56 up 45 min, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAhTCjkp5CsIXuxqURAhVGAJ90w9pULCucBiJ6Eay6avWqBteWPQCfQarM BpxA5MMayy8zdApxCfXDhec= =CUBy -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: error importing date
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes, I use the mysqldump command without any arguments. But, by the way, the timestamp is timestamp(10), is it correct? On Tuesday 20 April 2004 09:38 pm, Victor Pendleton wrote: Are you exporting/importing the DDL as well? Is the column type 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 responding. I really need help here. I export/import the database using mysqldump (for exporting), and the mysql command (for importing). One thing to be noted thought, the exported sql has correct timestamps (they're exactly the same when in still the database). Also, I found another interesting thing: When I modified the timestamps in the dumpfile, adding '00' at the end, example: from 0404121921 into 040412912100, it got imported correctly. What gives? I'm thinking of hacking the dumpfile adding '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 importing date Hi all, I encounter this error when importing database from one mysql server into another: the date imported is wrong. The type is timestamp. In the dump file, the date is : 0404121921, but when imported, it becomes: 0004041219. Could anybody pls 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:47:50 up 7:38, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key - -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org 22:17:51 up 1:51, Mandrake Linux release 9.2 (FiveStar) for i586 public key: https://www.arinet.org/fajar-pub.key -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFAhT9tkp5CsIXuxqURAowrAJ9+abLiuBXM0hiQ46Ms+RCJlaxtCACgkNNV 3ETlTD8S84OauheNRYAPuKI= =A44K -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php