By droople on

I am running the following

XP Pro
Apache2triad: PHP5 MySQL5)

now the problem is when I try to import a database (.sql file) I previously exported, it only picks up 15/16 tables instead of the whole database

It's not a huge file, just a 2MB file.

my post_max = 250MB
my upload_max= 200
my memory_limit = 250MB

What could be the problem??

⋅ Categories: Drupal 5.x

Comments

hagrin’s picture

hagrin commented

For the table that it is not picking up and importing, can you post the script for it? Is the table already created or are you also doing a CREATE in the import?

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

droople’s picture

droople commented

I have a database "db1" which I use for my site localhost/drupal

in phpmyadmin, i exported this database and saved it on my desktop as db1.sql

i then did some work on the site, and now want to restore to the "db1" settings.

so i dropped all tables, and tried to import the contents of db1.sql into the now empty db1.

All I can get is 15 tables out of the original 79

LiquidWeb’s picture

LiquidWeb commented

Although phpmyadmin is a great tool sometimes it fails to import SQL scripts, which created by phpmyadmin too. To avoid this kind of problems I recomend to use MySQL GUI programs like navicat and sqlyog. You can get SQLyog at http://webyog.com/ and navicat at http://www.navicat.com/ personally I prefer navicat but its a commercial program and you may find price high so first try SQLyog which also has a free noncommercial version.

droople’s picture

droople commented

will try one the community one

cheers