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 "oldpassw

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 run

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 ma

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(s

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.2

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.c

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://lis

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 pat

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 hardba

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 nig

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.s

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 to

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

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: > >

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]

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 P

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 e

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/ph

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: 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

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()

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 Configu

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

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 ---

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

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

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

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-f

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 tabl