phpMyAdmin error upgrade - XAMPP 1.7.7 to 1.8.0 [Solved]

[chris122380]

I have already looked through this forum and have tried all kinds of options given .
Error from phpMyAdmin

Code: Select all

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

I had a mysql password for root of root.
I have made a full backup of the old XAMPP directory.
I have removed the # from #bind-address="127.0.0.1" in my.ini
I have compared the my.ini with the old one with no needed changes.
I have compared the config.inc.php with the old one and there are no password changes made in there.

My PHP sites that use the mysql databases I created are working.

mysql error log:

Code: Select all

120801 10:48:08 [Note] Plugin 'FEDERATED' is disabled.
120801 10:48:08 InnoDB: The InnoDB memory heap is disabled
120801 10:48:08 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120801 10:48:08 InnoDB: Compressed tables use zlib 1.2.3
120801 10:48:08 InnoDB: Initializing buffer pool, size = 16.0M
120801 10:48:08 InnoDB: Completed initialization of buffer pool
120801 10:48:08 InnoDB: highest supported file format is Barracuda.
120801 10:48:08  InnoDB: Waiting for the background threads to start
120801 10:48:09 InnoDB: 1.1.8 started; log sequence number 3707206
120801 10:48:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
120801 10:48:09 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
120801 10:48:09 [Note] Server socket created on IP: '127.0.0.1'.
120801 10:48:09 [Note] Event Scheduler: Loaded 0 events
120801 10:48:09 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.25a'  socket: ''  port: 3306  MySQL Community Server (GPL)


Apache Error Logs:

Code: Select all

[Wed Aug 01 10:48:07.435303 2012] [core:warn] [pid 253200:tid 252] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Wed Aug 01 10:48:08.138343 2012] [ssl:warn] [pid 253200:tid 252] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Wed Aug 01 10:48:08.184346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00455: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4 configured -- resuming normal operations
[Wed Aug 01 10:48:08.184346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00456: Server built: May 13 2012 14:10:15
[Wed Aug 01 10:48:08.184346 2012] [core:notice] [pid 253200:tid 252] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Wed Aug 01 10:48:08.186346 2012] [mpm_winnt:notice] [pid 253200:tid 252] AH00418: Parent: Created child process 255708
[Wed Aug 01 10:48:09.992449 2012] [ssl:warn] [pid 255708:tid 264] AH01873: Init: Session Cache is not configured [hint: SSLSessionCache]
[Wed Aug 01 10:48:10.039452 2012] [mpm_winnt:notice] [pid 255708:tid 264] AH00354: Child: Starting 150 worker threads.


[chris122380]

I have a close fix but one error left. I whent back to my old version 1.7.7 and cleared the password using resetroot.bat and then copied the mysql data folder to the new version 1.8.0 (Took some renameing of files.) I reset my password back to what it was so that my websites would work.
I then get this error:

Code: Select all

Error
SQL query:  Edit

SELECT  `tables`
FROM `phpmyadmin`.`pma_recent`
WHERE  `username` = 'root'

MySQL said:

#1146 - Table 'phpmyadmin.pma_recent' doesn't exist


and

Code: Select all

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

if I comment out the two lines from config.inc.php It removes the first error but then I still have the sound one.

Code: Select all

// $cfg['Servers'][$i]['recent'] = 'pma_recent';
// $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

How do I get read of thease errors?

[JonB]

By using the information provided in the multiple 'stickies' in this forum about how to upgrade.

You cannot simple copy data files over between suite versions and expect them to work. Your problem is that the different versions of XAMPP contain different versions of phpMyAdmin - which - have different data structures.

Good Luck

[chris122380]

By using the information provided in the multiple 'stickies' in this forum about how to upgrade.

You cannot simple copy data files over between suite versions and expect them to work. Your problem is that the different versions of XAMPP contain different versions of phpMyAdmin - which - have different data structures.

Good Luck

'stickies'? none of the upgrade options I have seen say anything in detail on how to make the upgrade. I was fallowing directions givin all over the internet I mainly used
http://www.abouthack.com/articles/windows/how-to-update-xampp-in-windows.html
If you have any recomendations on upgrading or fixing my issue it would be helpfull (Please also sight links to original so if I need more detailes).

[JonB]

I read the article you cited - I don't know a thing about the author's qualifications (nor does he state them, or what versions it [the proposed conversion]was 'from' and 'to') - and I posted a 'I think is is inaccurate' post (and the specific reasons).

The answers you seek are at the top of this forum:


Good Luck


I also have a WordPress CMS on the DIY Server stuff - its in my 'sig line' (just click on it)

[chris122380]

I read the article you cited - I don't know a thing about the author's qualifications (nor does he state them, or what versions it [the proposed conversion]was 'from' and 'to') - and I posted a 'I think is is inaccurate' post (and the specific reasons).

The answers you seek are at the top of this forum:


Good Luck


I also have a WordPress CMS on the DIY Server stuff - its in my 'sig line' (just click on it)

I have already read through the top posts and non of them were helpfull with upgraqding or fixing this issue. However I did make a full backup and copy over the files as suggested by "How to 'upgrade' to XAMPP 1.8.0" with no luck.

[JonB]

A. You can't fix 'your issue' (after conversion)... because the data structure for phpMyAdmin is now different - that is why you got the 'table missing' error. You can't repair application metadata.

B. There is no place 'up there' where I tell you to copy your MySQL data folder. I specifically tell you how to avoid this issue:

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user! This is the safest route unless you know 'a lot' about MySQL Import/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.

I will now add more notes/steps -

X. Never ever try to recreate or copy application metadata - such as the database and tables for MySQL database engine itself or phpMyadmin - which is an application/shell for MySQL.

Y. Recreate your 'self-added' database users as described in A, and their privileges. Restore your MySQL user-created databases using phpMyAdmin, the MySql command line, or other MySQL management tools - like MySQL workbench. Always check the third party scripts you are using for compatibility/version issues (as stated twice before).

Z. NEVER EVER copy the entire MySQL toplevel 'data' folder, it contains metadata on the state of the MySQL installation and other data that may be specific to 'other application states'. You can, under some conditions, copy the data folders for individual databases/tables - you need to refer to the MySQL documentation before you attempt this, and understand the consequences, and the remediation that may be required. Only real MySQL experts attempt this (and usually because the database is corrupt or in an inconsistent state). I personally always user MySQL Workbench Export/Import (or Navicat). If you use the export/import methodology you will rarely go wrong.

http://dev.mysql.com/doc/refman/5.5/en/ ... eries.html

Good Luck




(BTW, I'm a MySQL database designer)

[chris122380]

A. You can't fix 'your issue' (after conversion)... because the data structure for phpMyAdmin is now different - that is why you got the 'table missing' error. You can't repair application metadata.

B. There is no place 'up there' where I tell you to copy your MySQL data folder. I specifically tell you how to avoid this issue:

A. Backup
Backup your 'custom' / user added MySQL databases. You can use the phpMyAdmin export tool, MySQL Workbench (free tool from Oracle), or the mysqldump.exe Command Line tool. Take screenshots of your database names, users and settings. Make SURE you know all the passwords and they are working (you can test by logging into phpMyAdmin as those users). You will probably have to 'add-back' any users 'you' created originally (like for the WordPress 'database user') and re-create the empty databases and the user privileges, don't forget the PMA control user! This is the safest route unless you know 'a lot' about MySQL Import/Export parameters. Copy out your HTDOCS, any user added Folders that are Aliased, and any Virtual Host folders.

I will now add more notes/steps -

X. Never ever try to recreate or copy application metadata - such as the database and tables for MySQL database engine itself or phpMyadmin - which is an application/shell for MySQL.

Y. Recreate your 'self-added' database users as described in A, and their privileges. Restore your MySQL user-created databases using phpMyAdmin, the MySql command line, or other MySQL management tools - like MySQL workbench. Always check the third party scripts you are using for compatibility/version issues (as stated twice before).

Z. NEVER EVER copy the entire MySQL toplevel 'data' folder, it contains metadata on the state of the MySQL installation and other data that may be specific to 'other application states'. You can, under some conditions, copy the data folders for individual databases/tables - you need to refer to the MySQL documentation before you attempt this, and understand the consequences, and the remediation that may be required. Only real MySQL experts attempt this (and usually because the database is corrupt or in an inconsistent state). I personally always user MySQL Workbench Export/Import (or Navicat). If you use the export/import methodology you will rarely go wrong.

http://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html

Good Luck




(BTW, I'm a MySQL database designer)

Thank you. All I did was backup my files from htdocs and make a backup of the database useing phpMyAdmin. I then renamed the XMAPP file and installed the new version. Copied backover my folder to htdocs and imported my database and made the needed changed to php.ini for xdecode to work. Everything seems to be correct now.

[JonB]

Great - That's good news.

Good Luck with XAMPP and your project.