Fwd: Backing up MySQL using PHPMyAdmin problem with UTF-8

2010-10-18 Thread Tompkins Neil
MySQL Administrator 1.2.15 is fails with the same problem. Do anyone have any other suggestions ? -- Forwarded message -- From: Tompkins Neil neil.tompk...@googlemail.com Date: Fri, Oct 15, 2010 at 11:21 AM Subject: Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

2010-10-15 Thread Tompkins Neil
Oh this isn't good. Because the database in on a shared server and I don't think I've got console access ? On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote: I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

2010-10-15 Thread Tompkins Neil
I managed to use the older version of MySQL Administrator 1.2.15 and it appears to back up find using InnoDB online backup. On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman mdyk...@gmail.com wrote: I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go

Backing up MySQL using PHPMyAdmin problem with UTF-8

2010-10-14 Thread Tompkins Neil
Hi, I'm using PHP MyAdmin to backup my MySQL database. The database is of type InnoDB and encoding used is utf8_unicode_ci. The variables are set as follows : *MySQL connection collation: **utf8_unicode_ci* *MySQL charset: **UTF-8 Unicode (utf8)* *character set client: utf8* *character set

Re: Backing up MySQL using PHPMyAdmin problem with UTF-8

2010-10-14 Thread Michael Dykman
I have had this problem with PHPMyAdmin many times, and the only way I know around it, is to go in and do your dump at the console. PHP does not deal with UTF very well. - michael dykman On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi, I'm using PHP

MySQL 5 / phpMyAdmin

2006-05-10 Thread Amer Neely
I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief. It gives me this error: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. #1251 - Client does not support authentication protocol requested by server;

RE: MySQL 5 / phpMyAdmin

2006-05-10 Thread George Law
try a search for old_password -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 10, 2006 1:39 PM To: MySQL List Subject: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my Win2K machine, but phpMyAdmin 2.8.0.3 is now giving me grief

RE: MySQL 5 / phpMyAdmin

2006-05-10 Thread Ing. Edwin Cruz
Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! -Mensaje original- De: Amer Neely [mailto:[EMAIL PROTECTED] Enviado el: MiƩrcoles, 10 de Mayo de 2006 12:39 p.m. Para: MySQL List Asunto: MySQL 5 / phpMyAdmin I've finally got MySQL 5.0 going on my

RE: MySQL 5 / phpMyAdmin - SOLVED

2006-05-10 Thread Amer Neely
Thanks to Ing. Edwin Cruz and George Law for pointing me in the right direction, as previous messages in this thread indicate. phpMyAdmin now working great with MySQL 5.0. Have a loot on this: http://dev.mysql.com/doc/refman/5.0/en/old-client.html try a search for old_password -- Amer

Re: MySQL and phpMyAdmin

2005-03-21 Thread Gleb Paharenko
Hello. I think you should rebuild php with the 4.1.10 libraries. Search in the archives at http://lists.mysql.com/mysql about successful solution for similar problem(s). See: http://dev.mysql.com/doc/mysql/en/old-client.html Asad Habib [EMAIL PROTECTED] wrote: I just

MySQL and phpMyAdmin

2005-03-19 Thread Asad Habib
I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both IE and Safari on Mac OS X Panther client. #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client I am

Re: MySQL and phpMyAdmin

2005-03-19 Thread Michael Stassen
Did you try searching on the error message first? I got hundreds of hits in Google for this. Searching the mysql docs, the first hit http://dev.mysql.com/doc/mysql/en/old-client.html has the explanation. The short version is that password security has been improved in mysql 4.1, so clients

Re: MySQL and phpMyAdmin

2005-03-19 Thread Karam Chand
Even I had the same problem so I moved to using SQLyog and its an awesom client. http://www.webyog.com Karam --- Asad Habib [EMAIL PROTECTED] wrote: I just installed phpMyAdmin, made the appropriate changes in the config.inc.php file, and got the following error when accessing it via both

Re: Mysql and PHPMYadmin

2004-08-03 Thread Barry Zimmerman
://www.fishingvenues.com -- From: Victor Pendleton [EMAIL PROTECTED] Date: Mon, 2 Aug 2004 13:46:02 -0500 To: 'Barry Zimmerman ' [EMAIL PROTECTED], '[EMAIL PROTECTED] ' [EMAIL PROTECTED] Subject: RE: Mysql and PHPMYadmin Do you know the ASCII values

Mysql and PHPMYadmin

2004-08-02 Thread Barry Zimmerman
Hi, Hoping that someone can help me, as I have tried everywhere for help and still cannot get this to work. I am using MySQL 4.1.1 I have a sql file that contains french accent characters. I have 8 fields in my database. Now the content of the text file imports into my database, when I import

Mysql and PhpMyadmin problem

2004-08-02 Thread Barry Zimmerman
Hi, Hoping that someone can help me, as I have tried everywhere for help and still cannot get this to work. I am using MySQL 4.1.1 I have a sql file that contains french accent characters. I have 8 fields in my database. Now the content of the text file imports into my database, when I import

RE: Mysql and PHPMYadmin

2004-08-02 Thread Victor Pendleton
Do you know the ASCII values for the characters that are being turned into question marks? Are you able to verify that the data is not be imported by querying the underlying ascii value? -Original Message- From: Barry Zimmerman To: [EMAIL PROTECTED] Sent: 8/2/04 1:00 PM Subject: Mysql

Re: Unable to connect to mysql with phpmyadmin

2004-04-05 Thread Michael Stassen
Marvin Cummings wrote: I finally managed to get this working. It turns out I was using the wrong password for the root account and once I remembered what the correct password was I was able to log in via phpMyAdmin. I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6. Now I want

RE: Unable to connect to mysql with phpmyadmin

2004-04-04 Thread Marvin Cummings
Phipps [mailto:[EMAIL PROTECTED] Sent: Saturday, April 03, 2004 11:38 PM To: Marvin Cummings Subject: RE: Unable to connect to mysql with phpmyadmin Are you using the username and password in the config file? or the username and password for sql? For phpmyadmin, you use the username and password

Re: Unable to connect to mysql with phpmyadmin

2004-04-04 Thread Michael Stassen
Marvin Cummings wrote: I've tried it both ways using the default root and no password and root with my assigned password. Either way returns an error. Here's a part of my config.inc.php file: // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can

RE: Unable to connect to mysql with phpmyadmin

2004-04-04 Thread Marvin Cummings
I finally managed to get this working. It turns out I was using the wrong password for the root account and once I remembered what the correct password was I was able to log in via phpMyAdmin. I'm using MySQL 5.0alpha with php4.3.4. and phpMyAdmin ver2.5.6. Now I want to switch the 'auth_type

Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Marvin Cummings
I'm wondering if someone could help me figure out why I'm getting this error when attempting to use phpMyAdmin to connect to mysql: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make

RE: Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Marvin Cummings
I see $cfg all over the place and no mention of HTTP. Where should I be looking for this? Thanks -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Saturday, April 03, 2004 9:36 PM To: Marvin Cummings Subject: Re: Unable to connect to mysql with phpmyadmin

RE: Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Marvin Cummings
missing something here and it's driving me crazy. Thanks for the help. -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Saturday, April 03, 2004 9:54 PM To: Marvin Cummings Subject: Re: Unable to connect to mysql with phpmyadmin I see $cfg all over the place

Re: Unable to connect to mysql with phpmyadmin

2004-04-03 Thread Michael Stassen
Marvin Cummings wrote: I'm wondering if someone could help me figure out why I'm getting this error when attempting to use phpMyAdmin to connect to mysql: phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password

error using mysql with phpmyadmin

2002-06-11 Thread MySQL
Has anyone ever had an error when using phpmyadmin to access MySQL similiar to the following error: Warning: Wrong parameter count for extract() in ./libraries/grab_globals.lib.php3 on line 18 I could not find the answer in any other lists. Any assistance in how to correct this might

urgent problem with mysql and phpmyadmin

2002-02-21 Thread Victoria Reznichenko
Andrew, Thursday, February 21, 2002, 3:31:16 AM, you wrote: AB I have created a table in the mysql db, using phpmyadmin with the following AB statement: AB create table books AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary AB key(isbn)); AB which works fine

urgent problem with mysql and phpmyadmin

2002-02-20 Thread Andrew Bunkell
I have created a table in the mysql db, using phpmyadmin with the following statement: create table books ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary key(isbn)); which works fine and creates the table i need the problem comes when i try to insert some values

RE: urgent problem with mysql and phpmyadmin

2002-02-20 Thread David McInnis
David McInnis -Original Message- From: Andrew Bunkell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 5:31 PM To: [EMAIL PROTECTED] Subject: urgent problem with mysql and phpmyadmin I have created a table in the mysql db, using phpmyadmin with the following statement

Using MySQL and phpmyadmin 2.2

2002-01-22 Thread Mark Stringham
I am running MySQL and using phpmyadmin 2.2 as the GUI. I noticed that if there is a lot of db activity - the overhead increases on various tables. What causes overhead ? I have looked into the MySQL docs and haven't really found much of an answer. Any help is appreciated. Mark