Koozali.org: home of the SME Server

5.6+6b3 backup restored on 6b3... phpmyadmin problem

Pierre BOUCHER

5.6+6b3 backup restored on 6b3... phpmyadmin problem
« on: December 17, 2003, 09:44:30 PM »
I had a server running on 5.6 updated to 6b3 postnuke and oscommerce running on it no problems.

I reloaded another server, with 6b3 and after, phpmyadmin wasn't working.
I reinstalled the phpmyadmin contrib, and it look like it's working fine.

 Except that i can't import  an updated sql database using a backup done with phpmyadmin on the other server.

It read the file and after a few secs i got a white page in phpmyadmin, nothing is done and no errors msg are given.


Thanks for your help!
Pierre BOUCHER

Greg Plater

Re: 5.6+6b3 backup restored on 6b3... phpmyadmin problem
« Reply #1 on: December 19, 2003, 12:31:42 PM »
i think this might help

mysql --force -u root -p "databasename" < Databasename.sql

this should work if you have a password set for your sql

Pierre BOUCHER

Re: 5.6+6b3 backup restored on 6b3... phpmyadmin problem
« Reply #2 on: December 19, 2003, 06:20:54 PM »
I tried and it didn't work,

It's just sitting here doing nothing, same as in phpmyadmin. But now i can assume that is something related to the mysql server.

I'm downloading the latest sme 6 to see if the update help.


Any other solutions?


Pierre BOUCHER

Pierre BOUCHER

phpmyadmin contrib don't work properly mith sme 6
« Reply #3 on: December 20, 2003, 06:01:29 AM »
I installed the phpmyadmin contrib, on a sme 6 clean install.
 phpmyadmin work fine but  i can't import database.

Any ideas???


Pierre BOUCHER

Pierre BOUCHER

Re: phpmyadmin contrib don't work properly mith sme 6
« Reply #4 on: December 21, 2003, 07:43:59 PM »
To who it may help.

I did the import and export to the other server from root console and everything worked fine...

Pierre BOUCHER

Boris

Re: 5.6+6b3 backup restored on 6b3... phpmyadmin problem
« Reply #5 on: December 21, 2003, 11:41:55 PM »
You may hit the PHP upload limit (2Mb) via web based phpmyadmin.
Increasing PHP MAX Upload size in the php.ini may help.

Pierre BOUCHER

Re: 5.6+6b3 backup restored on 6b3... phpmyadmin problem
« Reply #6 on: December 21, 2003, 11:46:16 PM »
BIg chance, you are right, because the DB is over 10 Mb

Pierre