Can we install newer phpMyAdmin?? - VoIP Forums, Internet Phone Service Forums, & Web Hosting Forums

middleground · #1 03-16-2002, 09:04 PM

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 · #2 03-18-2002, 01:56 AM

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 · #3 03-18-2002, 06:28 AM

Thanks, just wanted to make sure.

middleground · #4 03-20-2002, 09:40 AM

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 · #5 03-21-2002, 04:26 AM

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.