Basic Xampp Proper Operating Procedure Question

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

Basic Xampp Proper Operating Procedure Question

Postby Occido » 27. September 2013 18:22

Greetings everyone. I am not a tech neophyte by any means but honestly MySql etc is not my normal arena of operation. I have been tasked to develop a replacement website to an existing online one and they want it done in Wordpress. After researching how to do this I found this great Xampp program that allows me to accomplish this locally then when finished I can replace the outdated current online one.

I really like your program and found it very easy to install, configure and start using following your instructions. So off I went designing and such and at the end of the day I opened the Xampp control panel and stopped both Apache as well as the MySql service and closed everything down. The next day I went to restart Xampp and the services and Apache always seems to start no issue but then MySql would not start. I checked the log and saw the list of errors with notes about issues with tables and database files etc and had no idea how to fix it. I read a post online that deleting a file associated with the database or tables would allow MySql to start which I did then it did allow MySql to start but my website was then gone and had to redo the Wordpress install and start over. Since I was barely into development of the site I figured I may as well just redo the process of installing Xampp and start from scratch so I uninstalled everything and did from beginning again. Started Xampp redid creating database etc steps and then installed Wordpress and once again started creating my site. Again at the end of the day I shutdown Apache and MySql services and the following day went to start work and again Apache started fine but MySql once again had issues, different issues with ports or permissions or something and once again unable to work on my site.

So, sorry about this wall of text, what I want to know is there a proper startup and shutdown procedure i should follow to prevent this from occurring? As I said I am very early on in my work but if I get 95% done with everything and then it is lost I will probably jump out the window! Or is there a way to backup key files that can be used to replace ones that may become corrupted? As I said I really like Xampp and the fact that it allows me to work locally but these issues I have been having are making me scared to try again. I know I am instructed to copy the error log file contents and post them so you would be able to see specifically what the issue is and I would do again if it continues but I just want to first eliminate the possibility that is noob user error on my part with basic program operation. Again sorry for the long winded post and I thank you all for any help or advice that you may be able to provide to help this old nerd use your great program to accomplish my tasks.

Operating System I use is Windows Vista Ultimate if that makes any difference.
Occido
 
Posts: 3
Joined: 27. September 2013 17:43
Operating System: Vista Ultimate

MySql Database Backup & Sanity Question

Postby Occido » 30. September 2013 17:05

I have had a couple different issues with MySql becoming unable to startup through Xampp control panel and both times I have lost all work progress on a Wordpress website. My question is if I am sure to make ongoing regular backups of the MySql database through the myphpadmin area using the "export" function will this prevent any further loss again in the future? Or at least up to the point of the backup? Both times before I had not gotten too far into the website development but it has made me seriously worried about it happening again when I am much further into the website which would cause me to become suicidal. :cry:

Thanks in advance anyone who can help a Xampp / MySql noob out. I really appreciate it. <3
Occido
 
Posts: 3
Joined: 27. September 2013 17:43
Operating System: Vista Ultimate

Re: Basic Xampp Proper Operating Procedure Question

Postby Altrea » 03. October 2013 00:33

Hi Occido,

i have finally merged your threads because they report the same issue.
Please do not create multiple threads for the same issue and don't capture support threads of others for your own. Thank you.

The problem is a XAMPP issue with all XAMPP 1.8.3 versions so far.
Read more about that issue here:
viewtopic.php?f=16&t=66746#p230644

The recommend workaround would be to use XAMPP 1.8.2-2 instead.

Occido wrote:I checked the log and saw the list of errors with notes about issues with tables and database files etc and had no idea how to fix it.

If you have no idea, why don't you post these lines here so that someone else can take a look on it? Providing support without information is always difficult. Please next time provide as much information as possible.

Occido wrote:what I want to know is there a proper startup and shutdown procedure i should follow to prevent this from occurring?

The shutdown is the critical part. Instead of using the Stop button you could do something like this:

Hit the Shell button in your control panel, type in the following command
Code: Select all
mysqladmin shutdown --user=root --password

(You will be asked for your password of this user root. If you haven't set one it is simply blank.)

best wishes,
Altrea
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: Basic Xampp Proper Operating Procedure Question

Postby Occido » 03. October 2013 02:32

Hi Altrea,

I apologize for my improper forum etiquette, I guess I just let my panicked confusion get the better of me being desperate to prevent further losses of work. Regardless I should have known better and will not happen again. Thank you for cleaning up my mess of posts and a huge thank you for your help with answering my questions. I will be sure to take your advice with the shutdown method you provided and since I was waiting before re-installing Xampp when I do so I will use the 1.8.2-2 version to further prevent the issues I had previously.

If for whatever reason I have future issues I will be patient and be sure to include any error logs on here to provide background so that you or others may help educate me on the possible solution. Thanks again for your patience and your sanity saving help, I really appreciate your time and effort.

Best regards,
Occido
Occido
 
Posts: 3
Joined: 27. September 2013 17:43
Operating System: Vista Ultimate


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 123 guests