Re: Mysqldump alternative due to bug
There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can use to backup the database, until this bug is resolved in a future release? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stop the Server in Control Center not working
Hi All, I have connected to the server via MySQLAdministrator and tried stopping the server with this, but it still runs, mysql 3658 0.1 2.0 32160 5208 pts/1S+ 22:34 0:00 /usr/local/mysql/ bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mys ql --pid-file=/usr/local/mysql/data/localhost.localdomain.pid --skip-locking root 3800 0.0 0.2 3892 668 pts/4S+ 22:47 0:00 grep mysql Also, when starting mysql from the cli with the cmd mysql, which is a ln -s to the mysqld_safe script in /usr/local/mysql/bin shouldnm't I get a mysql prompt..? I just get the following, [EMAIL PROTECTED] ~]# mysql Starting mysqld daemon with databases from /usr/local/mysql/data Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
phpmyadmin can't connect via browser
Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stop the Server in Control Center not working
Mark Sargent wrote: I have connected to the server via MySQLAdministrator and tried stopping the server with this, but it still runs, Also, when starting mysql from the cli with the cmd mysql, which is a ln -s to the mysqld_safe script in /usr/local/mysql/bin Whoa! I think you need to stop and reinstall. `mysql` is the *client* executable, most definitely *not* a symlink to `mysqld_safe`. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Steve Buehler wrote: At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * What am I mising.? Cheers. This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve Hi All, Steve, below is how It looks after your suggestions, but, still with the same errors. Cheers. Mark Sargent. /** * Your phpMyAdmin url * * Complete the variable below with the full url ie * http://localhost/phpMyAdmin-2.6.1-pl3/ * * It must contain characters that are valid for a URL, and the path is * case sensitive on some Web servers, for example Unix-based servers. * * In most cases you can leave this variable empty, as the correct value * will be detected automatically. However, we recommend that you do * test to see that the auto-detection code works in your system. A good * test is to browse a table, then edit a row and save it. There will be * an error message if phpMyAdmin cannot auto-detect the correct value. * * If the auto-detection code does work properly, you can set to TRUE the * $cfg['PmaAbsoluteUri_DisableWarning'] variable below. */ $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpMyAdmin-2.6.1-pl3/'; /** * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set * You should use this if and ONLY if the PmaAbsoluteUri auto-detection * works perfectly. */ $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. Hi All, disregard that..Below is the start of the info displayed with phpinfo() in the browser. Cheers. phpinfo (PHP 3, PHP 4 , PHP 5) phpinfo -- Outputs lots of PHP information Description int *phpinfo* ( [int what] ) I'm figuring you wanted to know if php was working, yes..? I had already tested it, and it was. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: where do I input phpinfo(), browser or terminal..? Cheers. Either create a Web page with this in it: ?php phpinfo(); ? or if you have CLI (running `which php` returns something), just `php -i` will get you a long, not-too-formatted listing of what's compiled in your PHP installation. -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
If your php was built with mysql support, there will be a mysql section in the output of phpinfo(). Given your error message, I'd guess your php was not built with mysql support. Michael Mark Sargent wrote: Mark Sargent wrote: Hassan Schroeder wrote: Mark Sargent wrote: when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration What am I mising.? Cheers. Uh, mysql support in your PHP installation? :-) What does phpinfo() show? Hi All, where do I input phpinfo(), browser or terminal..? Cheers. Mark Sargent. Hi All, disregard that..Below is the start of the info displayed with phpinfo() in the browser. Cheers. phpinfo (PHP 3, PHP 4 , PHP 5) phpinfo -- Outputs lots of PHP information Description int *phpinfo* ( [int what] ) I'm figuring you wanted to know if php was working, yes..? I had already tested it, and it was. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
At 08:59 AM 3/13/2005, you wrote: Steve Buehler wrote: At 08:15 AM 3/13/2005, you wrote: Hi All, have installed into /var/www/html the dir phpMyAdmin-2.6.1-pl3 and changed the url path like below, but, when typing localhost/phpMyAdmin-2.6.1-pl3/index.php, I get the following, cannot load mysql extension, please check PHP Configuration Documentation http://localhost/phpMyAdmin-2.6.1-pl3/Documentation.html#faqmysql /** * Your phpMyAdmin url * * Complete the variable below with the full url ie http://localhost/phpMyAdmin-2.6.1-pl3/ * This probably isn't the problem in itself, but I thought I might share this with you. But here is how mine is setup: $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpmyadmin/'; That just assures me that I can use the IP address or domain name without it giving me a problem and I can also move the directory to another server without having to change this line each time. Where mine has /phpmyadmin/, you will of course need to change that to the directory it is in. Steve, below is how It looks after your suggestions, but, still with the same errors. Cheers. $cfg['PmaAbsoluteUri'] = 'http://'.$_SERVER[HTTP_HOST].'/phpMyAdmin-2.6.1-pl3/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; The link it gave you to look at the documentation has the following info: begin cut and paste-- [1.20] I receive the error cannot load MySQL extension, please check PHP Configuration. To connect to a MySQL server, PHP needs a set of MySQL functions called MySQL extension. This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysql.so or php_mysql.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called PHP-MySQL or something similar. end cut and paste Are you running this on windows or linux? I am running all of mine on RedHat 9, RHEL ES 3 RHEL ES 4 using rpms to install everything. So the version of PHP-MySQL that I am running on my RedHat 9 is php-mysql-4.2.2-17.2. Do you have the php-mysql installed if you are running on linux? If you are running on Windows...do you have php_mysql.dll installed? Can you connect to your database from ANY of your php scripts? Or is this the only one you can't connect from? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: show databases;
The first thing to do is to verify that things are as expected. In the root session, run SHOW GRANTS FOR [EMAIL PROTECTED] You should see something like this: +--+ | Grants for [EMAIL PROTECTED]| +--+ | GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY PASSWORD '' | | GRANT ALL PRIVILEGES ON `mydb`.* TO 'user'@'localhost' | | GRANT ALL PRIVILEGES ON `test`.* TO 'user'@'localhost' | +--+ If you did exactly what you showed us, however, grant all privileges on mydb to [EMAIL PROTECTED]; you will see something different. That command gives [EMAIL PROTECTED] rights to the **table** named mydb in whatever was the current database. In that case, you will probably want to use something like REVOKE ALL PRIVILEGES ON mydb FROM [EMAIL PROTECTED]; GRANT ALL PRIVILEGES ON mydb.* TO [EMAIL PROTECTED]; to fix it. See the manual http://dev.mysql.com/doc/mysql/en/grant.html for details on GRANT and REVOKE syntax. One other thing you can do is to run SELECT CURRENT_USER(); in the user session to verify that mysql agrees that you are [EMAIL PROTECTED] Michael l'eau wrote: I am on linux Fedora 2 with mysqld running as a daemon and the service mysql running (/etc/rc.d/init.d/). I have two shell sessions (mysql client) running one with root and the other with a user. I did (as root) : grant all privileges on mydb to [EMAIL PROTECTED]; in the root session the show databases; return 3 databases (test, mysql, mydb) in the user session the show databases; return 1 database (test) what is going on? thanks laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump alternative due to bug
Ya, all my tables are InnoDB unfortunately, and they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa [EMAIL PROTECTED] wrote: There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can use to backup the database, until this bug is resolved in a future release? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump alternative due to bug
You can copy mysql tables files directly from /var/lib/mysql/data directory (or wherever your path/to/mysql is :) For more details/information, read this : http://dev.mysql.com/doc/mysql/en/disaster-prevention.html - Amr Scott Klarenbach wrote: Ya, all my tables are InnoDB unfortunately, and they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa [EMAIL PROTECTED] wrote: There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can use to backup the database, until this bug is resolved in a future release? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump alternative due to bug
Check this one too: http://dev.mysql.com/doc/mysql/en/backing-up.html - Amr Scott Klarenbach wrote: Ya, all my tables are InnoDB unfortunately, and they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa [EMAIL PROTECTED] wrote: There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can use to backup the database, until this bug is resolved in a future release? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql-query-browser-bin: error while loading shared libraries: libtiff.so.3
Hello, I am trying to run mysql query browser on debian, but... # ./mysql-query-browser ./mysql-query-browser-bin: error while loading shared libraries: libtiff.so.3: cannot open shared object file: No such file or directory Looks like I have libtiff.so.4. # ls libtiff* libtiff.so.4 libtiff.so.4.0.0 What should I do? Mysql administrator works. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Wrong bytesec nightmare!
Hello all, I am getting quite desperate on this, since I've been trying to recover my diary of a whole year of travelling which was stored in a MyISAM table for a couples of weeks now! The MySQL server was running in a XP machine and suddenly the hard disk crashed starting my particular nightmare. I had to use recovery tools to scan the disk and I thought I was saved when I found the *.frm, *.MYI and *.MYD files and was able to recover them, but when I tried get the tables back into MySQL and backup their contents, I found a series of errors that have kept me down ever since! The first complain I got when I selected the table was: Didn't find any fields in table 'news' I then checked the table for errors, and got: mysql check table news; +--+---+-- +-+ | Table| Op| Msg_type | Msg_text | +--+---+-- +-+ | ver.news | check | error| Incorrect information in file: './ver/news.frm' | +--+---+-- +-+ 1 row in set (0.03 sec) I checked it with myisamchk and got: Curro:/usr/local/mysql/bin root# ./myisamchk ../data/ver/news myisamchk: error: '../data/ver/news' is not a MyISAM-table I was reading the manual and since I had the description of the original tables, I created new tables with the same structure and used the *.frm files. With myisamchk I got the same error, but with CHECK TABLE the error changed and got: mysql check table news; +--+---+-- +--+ | Table| Op| Msg_type | Msg_text | +--+---+-- +--+ | ver.news | check | error| Can't open file: 'news.MYI' (errno: 130) | +--+---+-- +--+ 1 row in set (0.01 sec) Which meant I guess, the file is corrupted: MySQL error: 130 = Incorrect file format I then used the new *.MYI and got the following errors: Curro:/usr/local/mysql/bin root# ./myisamchk ../data/ver/news Checking MyISAM file: ../data/ver/news Data records: 0 Deleted blocks: 0 - check file-size myisamchk: warning: Size of datafile is: 848484 Should be: 0 - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check record links myisamchk: error: Wrong bytesec: 154-126-101 at linkstart: 0 MyISAM-table '../data/ver/news' is corrupted Fix it using switch -r or -o mysql check table news; +--+---+-- ++ | Table| Op| Msg_type | Msg_text | +--+---+-- ++ | ver.news | check | warning | Size of datafile is: 848484 Should be: 0 | | ver.news | check | error| Wrong bytesec: 154-126-101 at linkstart: 0 | | ver.news | check | error| Corrupt | +--+---+-- ++ 3 rows in set (0.10 sec) I searched the web to try to find a fix but I couldn't find any solved problem similar to this, with the Wrong bytesec at linkstart 0. I tried to repair the tables, and both the REPAIR TABLE and the myisamchk repairs using the newly created .frm and .MYI files resulted in an empty set, a truncated data file. I also tried with REPAIR TABLE .. USE_FRM with no luck, always complaining first of the 'Wrong bytesec' and then finding the blocks either that point outside data file or too small. Here is an extract of the result: mysql repair table news USE_FRM; +--++-- +--- ---+ | Table| Op | Msg_type | Msg_text | +--++-- +--- ---+ | ver.news | repair | info | Wrong bytesec: 154-126-101 at 0; Skipped | | ver.news | repair | info | Found block that points outside data file at 488 | | ver.news | repair | info | Found block that points outside data file at 544 | | ver.news | repair | info | Found block with too small length at 896; Skipped| | ver.news | repair | info | Found block with too small length at 1120; Skipped | | ver.news | repair | info | Found link that points at -4170694140902777944 (outside data file) at 1148 | | ver.news | repair | info | Found block that points outside
RE: Auto loading a table
[Donny Lairson] Quick bump I never got an answer I have a table fsearch_temp I use it as a memory table to keep things light and fast but after a restart I want to repopulate some data automatically. So I thought I just said load from TEST2 which would by a myisam table containing the hardbackup I need. But obviously not the right way of saying this. I must be reading the instructions wrong can someone clarify this for me? CREATE TABLE `fsearch_temp` ( `fsearchId` bigint( 19 ) unsigned NOT NULL AUTO_INCREMENT , `fsearchHost` varchar( 100 ) NOT NULL default '', `fsearchSite` varchar( 255 ) NOT NULL default '', `fsearchDescription` varchar( 255 ) NOT NULL default '', `fsearchUrl1` varchar( 255 ) NOT NULL default '', `fsearchUrl2` varchar( 255 ) NOT NULL default '', `fsearchUrl3` varchar( 255 ) NOT NULL default '', `fsearchUrl4` varchar( 255 ) NOT NULL default '', `fsearchTime` int( 11 ) NOT NULL default '0', `fsearchIp` varchar( 22 ) NOT NULL default '', `fsearchKeyword` varchar( 100 ) NOT NULL default '', `fsearchBid` varchar( 11 ) NOT NULL default '0', `fsearchClicked` varchar( 6 ) NOT NULL default 'no', PRIMARY KEY ( `fsearchId` ) , KEY `fsearchIp` ( `fsearchIp` ) ) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0 Thanks Donny Lairson President 29 GunMuse Lane P.O. box 166 Lakewood NM 88254 http://www.gunmuse.com 469 228 2183
Re: Mysqldump alternative due to bug
Awesome, I guess that's the best alternative. In fact, I was logging on to ask you that very question. Thanks, Scott. On Sun, 13 Mar 2005 20:03:15 +0200, Amr Mostafa [EMAIL PROTECTED] wrote: You can copy mysql tables files directly from /var/lib/mysql/data directory (or wherever your path/to/mysql is :) For more details/information, read this : http://dev.mysql.com/doc/mysql/en/disaster-prevention.html - Amr Scott Klarenbach wrote: Ya, all my tables are InnoDB unfortunately, and they need to stay that way ;-). On Sun, 13 Mar 2005 13:48:26 +0200, Amr Mostafa [EMAIL PROTECTED] wrote: There is the mysqlhotcopy, it's faster too. However, It will only work if all your tables are MyIsam. Scott Klarenbach wrote: I'm using Mysql 5.0.2 w/ Windows 2003 server, and there is a bug with the mysqldump utility. The bug is actually with the Describe table statement, or Show fields from table statement... It's been documented on mysql.com, so I'm wondering if there is a simple alternative to mysqldump that I can use to backup the database, until this bug is resolved in a future release? Thanks, Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Obtaining a List of Available MySQL Functions
Does anyone know an easy way to get a list of all MySQL Functions that can be used within queries? I've looked at the docs and tried all the obvious stuff (show func...etc). Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Obtaining a List of Available MySQL Functions
In the last episode (Mar 13), James Kiser said: Does anyone know an easy way to get a list of all MySQL Functions that can be used within queries? I've looked at the docs and tried all the obvious stuff (show func...etc). ? The documentation has a whole chapter on it. http://dev.mysql.com/doc/mysql/en/functions.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problems installing MySQL 4.0.24 on a Fedora Core 3 x86 box
Hello, I have Fedora Core 3 kernel 2.6.10-1.770_FC3smp It is a dual Xenon PIII server. I am trying to install MySQL 4.0.24 as I usually do: - There are no other mysql servers present, no 3.x as I did not install it. - I run rpm -ivh MySQL-client-4.0.24-0.i386.rpm - I run rpm -ivh MySQL-server-4.0.24-0.i386.rpm It installs the server Then I try to run MySQL but it does not run. Instead I have a .err file under /var/lib/mysql saying mysqld started and mysqld ended. I have done so many MySQL installs before and so I cannot understand why I cannot install it now on this server. The tables are not created not even if I run mysql_install_db. Is there any dependency that is missing? Any necessary library? Any ideas? Thank you, C.F. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: phpmyadmin can't connect via browser
Hassan Schroeder wrote: Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) Hi All, guys, I'm using Fedora3(sorry for not saying that earlier). I had problems with the rpm install of MySQL, so, went with installing the tar file. I installed php via yum, though. I did a rpm -q php-mysql which showed it not installed. I then did a yum install php-mysql which showed the following, [EMAIL PROTECTED] ~]# yum install php-mysql Setting up Install Process Setting up Repo: dag repomd.xml100% |=| 1.1 kB00:00 Setting up Repo: base repomd.xml100% |=| 1.1 kB00:00 Setting up Repo: updates-released repomd.xml100% |=| 951 B00:00 Reading repository metadata in from local files dag : ## 1932/1932 base : ## 2622/2622 primary.xml.gz100% |=| 298 kB00:09 MD Read : ## 706/706 updates-re: ## 706/706 Resolving Dependencies -- Populating transaction set with selected packages. Please wait. --- Downloading header for php-mysql to pack into transaction set. php-mysql-4.3.10-3.2.i386 100% |=| 15 kB00:01 --- Package php-mysql.i386 0:4.3.10-3.2 set to be installed -- Running transaction check -- Processing Dependency: libmysqlclient.so.10 for package: php-mysql -- Restarting Dependency Resolution with new changes. -- Populating transaction set with selected packages. Please wait. --- Package mysql.i386 0:3.23.58-14 set to be installed -- Running transaction check -- Processing Dependency: perl-DBD-MySQL for package: mysql -- Restarting Dependency Resolution with new changes. -- Populating transaction set with selected packages. Please wait. --- Downloading header for perl-DBD-MySQL to pack into transaction set. perl-DBD-MySQL-2.9003-5.i 100% |=| 5.3 kB00:00 --- Package perl-DBD-MySQL.i386 0:2.9003-5 set to be installed -- Running transaction check Dependencies Resolved Transaction Listing: Install: php-mysql.i386 0:4.3.10-3.2 Performing the following to resolve dependencies: Install: mysql.i386 0:3.23.58-14 Install: perl-DBD-MySQL.i386 0:2.9003-5 Is this ok [y/N]: y Downloading Packages: php-mysql-4.3.10-3.2.i386 100% |=| 32 kB00:01 perl-DBD-MySQL-2.9003-5.i 100% |=| 111 kB00:00 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: mysql 100 % done 1/3 Installing: php-mysql 100 % done 2/3 Installing: perl-DBD-MySQL 100 % done 3/3 Installed: php-mysql.i386 0:4.3.10-3.2 Dependency Installed: mysql.i386 0:3.23.58-14 perl-DBD-MySQL.i386 0:2.9003-5 Complete! It looks to have re-installed mysql again. Does this mean I now have the mysql database installed 2 times..? Seems like it, yes..? Now, 2 things I need to ask, 1. How do I determine whether I need to configure php to work with mysql and 2. how do I actually configure if needed.? Cheers. P.S. After the yum install and an updatedb I did a search for php-mysql via which wheris and locate, below is the results. [EMAIL PROTECTED] ~]# updatedb [EMAIL PROTECTED] ~]# which php-mysql /usr/bin/which: no php-mysql in (/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin) [EMAIL PROTECTED] ~]# whereis php-mysql php-mysql: [EMAIL PROTECTED] ~]# locate php-mysql /var/cache/yum/updates-released/packages/php-mysql-4.3.10-3.2.i386.rpm /var/cache/yum/updates-released/headers/php-mysql-4.3.10-3.2.i386.hdr Hope I've given enuff info this time. Cheers, again. (Oh, btw, I'm not a php programmer etc, I'm just doing this so I can say to a future employer, yes, I can install/setup/config php/mysql etc if you need it). Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
regarding cron
hi i have a prgrm which dumps the data extracted from the txt file to database. i want to run it using cron daily.i m using mysql as backend. when i run this program using my shell script it will run and insert data into the database. but when i give the same in cron it will not work ? what may be the reason ? i chked for the line is cronas i hve other shell script for other progms ...they all will run but only this will not run. i hv given like this in cron : 30 12 * * * /ncm/p.sh /dev/null 21 the shellscript will run the perl program. if i do sh p.sh then everything works fine. but if i run using cron it will not run. any ideas as to why this is happening? kavitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: regarding cron
Check your environment when run from cron. Ensure you have full pathnames to your perl script as quite often the $PATH will not be the same as when you ran it from your shell script. Also check any other environment variables you are using and ensure they are set from the shell script prior to running your perl script. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: N. Kavithashree [mailto:[EMAIL PROTECTED] Sent: Monday, 14 March 2005 5:00 PM To: mysql@lists.mysql.com Subject: regarding cron hi i have a prgrm which dumps the data extracted from the txt file to database. i want to run it using cron daily.i m using mysql as backend. when i run this program using my shell script it will run and insert data into the database. but when i give the same in cron it will not work ? what may be the reason ? i chked for the line is cronas i hve other shell script for other progms ...they all will run but only this will not run. i hv given like this in cron : 30 12 * * * /ncm/p.sh /dev/null 21 the shellscript will run the perl program. if i do sh p.sh then everything works fine. but if i run using cron it will not run. any ideas as to why this is happening? kavitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: phpmyadmin can't connect via browser
I dont remember exactly what you have to do, But there is password incompability between versions of MySQL, latest versions doesnt accept the old password type. (I copied some MySQL raw datafiles from one computer to another, and I got the same problem as you) Research MySQL website for oldpassword or something, then you should find your answer. Regards Robert. -Mensagem original- De: Mark Sargent [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 14 de março de 2005 01:35 Para: mysql Assunto: Re: phpmyadmin can't connect via browser Hassan Schroeder wrote: Mark Sargent wrote: I'm figuring you wanted to know if php was working, yes..? No, I wanted to know if your PHP was compiled with MySQL support. It doesn't have to be, and in your case seems it probably *isn't*. But we still don't know :-) Hi All, guys, I'm using Fedora3(sorry for not saying that earlier). I had problems with the rpm install of MySQL, so, went with installing the tar file. I installed php via yum, though. I did a rpm -q php-mysql which showed it not installed. I then did a yum install php-mysql which showed the following, [EMAIL PROTECTED] ~]# yum install php-mysql Setting up Install Process Setting up Repo: dag repomd.xml100% |=| 1.1 kB 00:00 Setting up Repo: base repomd.xml100% |=| 1.1 kB 00:00 Setting up Repo: updates-released repomd.xml100% |=| 951 B 00:00 Reading repository metadata in from local files dag : ## 1932/1932 base : ## 2622/2622 primary.xml.gz100% |=| 298 kB 00:09 MD Read : ## 706/706 updates-re: ## 706/706 Resolving Dependencies -- Populating transaction set with selected packages. Please wait. --- Downloading header for php-mysql to pack into transaction set. php-mysql-4.3.10-3.2.i386 100% |=| 15 kB 00:01 --- Package php-mysql.i386 0:4.3.10-3.2 set to be installed -- Running transaction check -- Processing Dependency: libmysqlclient.so.10 for package: php-mysql -- Restarting Dependency Resolution with new changes. Populating -- transaction set with selected packages. Please wait. --- Package mysql.i386 0:3.23.58-14 set to be installed -- Running transaction check -- Processing Dependency: perl-DBD-MySQL for package: mysql Restarting -- Dependency Resolution with new changes. Populating transaction set -- with selected packages. Please wait. --- Downloading header for perl-DBD-MySQL to pack into transaction set. perl-DBD-MySQL-2.9003-5.i 100% |=| 5.3 kB 00:00 --- Package perl-DBD-MySQL.i386 0:2.9003-5 set to be installed -- Running transaction check Dependencies Resolved Transaction Listing: Install: php-mysql.i386 0:4.3.10-3.2 Performing the following to resolve dependencies: Install: mysql.i386 0:3.23.58-14 Install: perl-DBD-MySQL.i386 0:2.9003-5 Is this ok [y/N]: y Downloading Packages: php-mysql-4.3.10-3.2.i386 100% |=| 32 kB 00:01 perl-DBD-MySQL-2.9003-5.i 100% |=| 111 kB 00:00 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: mysql 100 % done 1/3 Installing: php-mysql 100 % done 2/3 Installing: perl-DBD-MySQL 100 % done 3/3 Installed: php-mysql.i386 0:4.3.10-3.2 Dependency Installed: mysql.i386 0:3.23.58-14 perl-DBD-MySQL.i386 0:2.9003-5 Complete! It looks to have re-installed mysql again. Does this mean I now have the mysql database installed 2 times..? Seems like it, yes..? Now, 2 things I need to ask, 1. How do I determine whether I need to configure php to work with mysql and 2. how do I actually configure if needed.? Cheers. P.S. After the yum install and an updatedb I did a search for php-mysql via which wheris and locate, below is the results. [EMAIL PROTECTED] ~]# updatedb [EMAIL PROTECTED] ~]# which php-mysql /usr/bin/which: no php-mysql in (/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sb in:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin) [EMAIL PROTECTED] ~]# whereis php-mysql php-mysql: [EMAIL PROTECTED] ~]# locate php-mysql /var/cache/yum/updates-released/packages/php-mysql-4.3.10-3.2.i386.rpm /var/cache/yum/updates-released/headers/php-mysql-4.3.10-3.2.i386.hdr Hope I've given enuff info this time. Cheers, again. (Oh, btw, I'm not a php programmer etc, I'm just doing this so I can say to a future employer, yes, I can install/setup/config php/mysql etc if you need it). Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
