Can we install newer phpMyAdmin??

[middleground]

Hi all,
In trying to do SQL dumps through phpMyAdmin, and then doing a restore into another database to test. I always get some errors and never works.

What I am doing I have done on another host with phpmyadmin 2.20 (basically the exact type of data and method).

My question is: Can we install a newer version of phpMyAdmin?
(as HR seems to be holding at 2.10)

Thanks,

[neographis]

You bet. I was getting really tired of 2.1 on my server as it didn't do proper dumps at all.

What I did is take 2.2.3 off of sourceforge and uploaded it into a folder called phpMyAdmin223. Then password protect that directory in your control panel. Be sure to edit the config file of the new phpmyadmin to set your DSN (localhost) and user/pass. Just set them to the same user/pass you set in the mysql manager. Works a lot better.

Little side note...i found someone had made a couple test databases in my mysql set. They don't show up in the mysql manager, but they show up in phpmyadmin223. Don't know if that's an HR bug from a restore process at one point or what.

[middleground]

Thanks, just wanted to make sure.

:)

[middleground]

Note- this fixed all my previous problems with dump / load of a database with phpMyAdmin.

V2.1.0 definitely has problems with this- recommend upgrade to everyone (well- only if you want good backups)

:)

[neographis]

Right! I'm guessing you were getting errors on reinserting .sql files. Somehow 2.1.0 didn't properly add slashes to escape special characters on a dump. So when you went to insert the backup file, it puked and didn't insert anything. Really annoying. And here for a year I thought I was getting proper backups of my db's. I feel lucky now having put the newer versions in considering what's been going on here recently.