phpmyadmin

**synaptech** · 23 May 2006, 04:50 PM

Hi,

I am having trouble with phpmyadmin either 2.6.2 or 2.8.1; specifically I can't seem to re-import the SQL dump file into a new database. I have looked in the FAQ's, the DOC's, and the forum but I can't seem to find explicit instructions as to what needs to be enabled for a successful transfer.

Using these instructions (which has worked in the past - but don't work now....which is why I am posting)

3. Make a COMPLETE backup of your DATABASE and STORE.
a. Use either the "Backup MySQL Database" contribution under Admin->Tools to do
the backup of your database, or use phpMyAdmin to export your entire database ...
include the "DROP" tables command, and under Data, choose "Complete Inserts"
and "Extended Inserts".

Save the SQL file to your PC for later.

When importing the dump file with phpmyadmin 2.6.2 I get a SQL query error saying there is no data. My file is about 3.6M and opening it in a text editor does in fact reveal data.

When using phpmyadmin 2.8.1 I get the following error : " import.php: Missing parameter: import_type
import.php: Missing parameter: format

So, what are the recommended phpmyadmin EXPORT settings? I am doing something fundamentally wrong.

Thanks

**synaptech** · 23 May 2006, 11:52 PM

An update,

I failed utterly with PHPMYADMIN, I attempted to use the Mysql Backup Mod and it couldn't find the MYSQLDUMP executable and had repeated errors. Sooo, I downloaded an App called Navicat and it rocked and rolled. Success.

I am using a Mac OSX server v10.3.9. I don't know if the mysql or php daemon or something else is hosed. They work fine in every other respect, the cart is upgraded to 1.3.1 and everything tests out ok.

If anyone has any insight as to why phpmyadmin is failing I would love to know.

**TheOracle** · 24 May 2006, 12:35 AM

If anyone has any insight as to why phpmyadmin is failing I would love to know.

From my personal opinion, I'd say you did pretty well on using navicat for this. I really like their software interface. Pretty simple to use and understand it's basis.

**synaptech** · 24 May 2006, 01:55 AM

Agreed Oracle,

As a total noob, the interface helped tremendously for troubleshooting. I think I might submit a tutorial for review for the rest of us OSX folk. Hopefully, I can keep someone else from spending a day doing this.

**Parafanaylya** · 8 Jun 2006, 02:05 PM

I haven't the error message for my issue, but I am trying another approach.

Can I delete specific fields in the new database and then import the same fields from the old database. I don't want to import the whole database as there's a whole lot of info I don't want in my new site.

**TheOracle** · 8 Jun 2006, 02:36 PM

Can I delete specific fields in the new database and then import the same fields from the old database.

Even better. With mySQL-Front Software, you can easily send old fields to new fields - all by wizard interface process (left to right window). Which means, no need to delete any fields in order to accomplish this.

It's easy, efficient and quickly done !

**Parafanaylya** · 8 Jun 2006, 02:45 PM

sourforge.net?

**TheOracle** · 8 Jun 2006, 04:15 PM

No, this one is available from: http://www.mysql-front.de .

**Parafanaylya** · 8 Jun 2006, 04:20 PM

Thanx - I'll give it a go

**DrByte** · 8 Jun 2006, 08:41 PM

Originally Posted by synaptech

When importing the dump file with phpmyadmin 2.6.2 I get a SQL query error saying there is no data.

This is usually a result of mismatched MySQL versions ... you did a backup from v3.x and tried to restore to 4.x.

Originally Posted by synaptech

So, what are the recommended phpmyadmin EXPORT settings?

Doing Backups with phpMyAdmin

There is an option in the newer phpMyAdmin interfaces to select a MySQL compatibility mode before exporting ... if you know you're moving from an older version to a newer version, you are advised to select the newer-version value from the compatibility pulldown menu.