Upgrade 1.7.x to 1.8.x - tables DB crash!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby tab » 19. July 2013 18:30

Hi,
I upgraded my old version of xampp (1.7.2) to the last stable version (1.8.2).
I had previously made ​​a backup of
- htdocs
- mysql/data/
Now, many of the DBs in phpmyadmin are without tables. Why?
tab
 
Posts: 4
Joined: 19. July 2013 18:17
Operating System: windows 8

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby hackattack142 » 19. July 2013 22:02

Hello,

Depending on the storage engine you are using, you cannot just copy the files over.

If you still have the old folder, I recommend exporting your databases to a SQL file and reimporting them in the new version.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby tab » 22. July 2013 14:05

Hello,
is there a way to export each database in only one SQL command?
tab
 
Posts: 4
Joined: 19. July 2013 18:17
Operating System: windows 8

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby hackattack142 » 23. July 2013 01:54

Yes, you can use the command line mysqldump program in the '/xampp/mysql/bin' folder.

You could script it to do something like
Code: Select all
mysqldump -uroot -ppassword dbname > dbname.sql

if you have a password set. If your root password is still blank, you can do
Code: Select all
mysqldump -uroot  dbname > dbname.sql

This will not add drop/create database statements to the dump. You should consult the many export options to enable that stuff.

There are many export options. You can do
Code: Select all
mysqldump --help
for more information.
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby MarjWyatt » 02. October 2013 08:42

I am running Xampp 1.7.3 on my Windows XP Laptop. I have nearly 100 active development projects within my installation and want to make sure that I'm understanding what is needed to upgrade to the latest stable version of Xampp.

I have read this thread> http://community.apachefriends.org/f/viewtopic.php?f=16&t=50988

Backing up essential files and configurations seems pretty straightforward but, for what ought to be obvious reasons, I want to ensure that I don't create a whole lot of unnecessary work for myself with this upgrade. The last time I did this, it didn't go well.

Am I gleaning from this thread that I must export each development's database (nearly 100) and import those databases into the new environment?
MarjWyatt
 
Posts: 12
Joined: 03. April 2010 01:02

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby Altrea » 02. October 2013 10:03

MarjWyatt wrote:want to make sure that I'm understanding what is needed to upgrade to the latest stable version of Xampp.

Is an upgrade really neccessary? Not always is newer equals better.

MarjWyatt wrote:I have read this thread> viewtopic.php?f=16&t=50988

Backing up essential files and configurations seems pretty straightforward but, for what ought to be obvious reasons, I want to ensure that I don't create a whole lot of unnecessary work for myself with this upgrade

This thread is a best practice to prevent known issues. You don't have to follow all steps if you don't want to. It's your system.

MarjWyatt wrote:Am I gleaning from this thread that I must export each development's database (nearly 100) and import those databases into the new environment?

Clean exports of databases (especially for InnoDB Databases) are always highly recommend, at best with the mysql included tool mysqldump.
saving and recopying the mysql data folder CAN work, but not in all cases.

At the end: more backups are always more backups are always more backups ...
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby MarjWyatt » 05. October 2013 08:22

My reason for wanting to upgrade is primarily because i would like a newer version of PHP (5.4) so my development is aligned with my hosting services.

@Altrea ... you wrote :
"This thread is a best practice to prevent known issues. You don't have to follow all steps if you don't want to. It's your system."

I understand that I don't have to follow all steps and that it is my system. What I was trying to understand and apparently asked poorly if this was THE method for upgrading.

Is there a way to export the entire set of databases in local host with one command rather than exporting each database individually?

Thanks for your previous reply and thank you, in advance, to anyone who responds in the future.
Last edited by MarjWyatt on 05. October 2013 21:03, edited 1 time in total.
MarjWyatt
 
Posts: 12
Joined: 03. April 2010 01:02

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby Altrea » 05. October 2013 09:47

Hi MarjWyatt,

MarjWyatt wrote:What I was trying to understand and apparently asked poorly if this was THE method for upgrading.

What answer do you expect now? There is NO ultimate outstanding upgrade method to master all ever possible situations. Systems are different and you should know your system to understand what steps of a specific HowTo you don't have to follow to backup and upgrade successful.

MarjWyatt wrote:Is there a way to export the entire set of databases in local host with one command rather than exporting each database individually?

mysqldump --all-databases
Be careful with database users and passwords. You should google how to move them correctly, for example this way:
http://geroldm.com/2012/10/migrate-mysq ... nt-server/

best wishes,
Altrea

P.S.:
MarjWyatt wrote:@Altera ... you wrote :

If you can't write my name correctly please omit it or copy it. That is not the most important thing in the world, but i don't like that :D
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby MarjWyatt » 05. October 2013 20:58

Apologies for mis-spelling your name. Thanks for the reply.

I'll not come back with more questions of you. Your tone is unnecessarily unpleasant. I did not like the "what do you expect now" opener.
MarjWyatt
 
Posts: 12
Joined: 03. April 2010 01:02

Re: Upgrade 1.7.x to 1.8.x - tables DB crash!

Postby Altrea » 05. October 2013 22:17

MarjWyatt wrote:I'll not come back with more questions of you. Your tone is unnecessarily unpleasant. I did not like the "what do you expect now" opener.

Sorry, i didn't want to be rude. That was a serious question. And i tried to answer it as good as i can.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 93 guests