You are here

MySQL in XAMPPlite

7 posts / 0 new
Last post
chillicane
Offline
Last seen: 15 years 5 months ago
Joined: 2007-09-04 06:23
MySQL in XAMPPlite

Having trouble getting MySQL in XAMPPlite to work on different machine from the one i set up on intially.

Set up database on XP machine on V: drive and now cannot get ANY mysql databases to work on a windows 2000 machine on K: drive using the USB key. I get the error.

Incorrect information in file: '.\\.frm'

for all databases and tables loaded in my database setup. All MySQL references to this error appear to be releated to long closed bugs in old MySQL setups

Anyone got any ideas? It really looks like XAMPP isnt too portable after all!

John T. Haller
John T. Haller's picture
Online
Last seen: 11 min 6 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Location

You MUST install XAMPP to the root directory of your device and NOT run the setup bat included with it. If you don't follow those two instructions, you'll see the errors you are encountering. The fix is to reinstall from scratch and follow those two instructions.

Sometimes, the impossible can become possible, if you're awesome!

chillicane
Offline
Last seen: 15 years 5 months ago
Joined: 2007-09-04 06:23
Root or Folder

I unzipped XAMPP lite into the root of the device so it appears like

:\xampplite\...

with the xampp_start, control, portcheck etc EXE files int he xampplite directory. is this what you mean by installing to the root? Or do i need to place the contents of the xampplite dir in the root of the device? Since i've borked the MySQL databases anyway ill give that a try and post back. Btw if i didnt mention in i installed on a WinXP machine and was attempting to run last night on a Win2K machine.

This will be a most excellent setup if i can get it to work consistently. I see endless possibilities.

Ryan McCue
Ryan McCue's picture
Offline
Last seen: 13 years 4 months ago
Joined: 2006-01-06 21:27
.

Why don't you package it without the setup.bat?
----
Ryan McCue.
Blog.
So all that Airbus-delay trouble over here in Europe is because of YOU!
Simeon.

"If you're not part of the solution, you're part of the precipitate."

John T. Haller
John T. Haller's picture
Online
Last seen: 11 min 6 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Nope

I don't repackage XAMPP right now. Lots of extra work for little purpose.

Sometimes, the impossible can become possible, if you're awesome!

chillicane
Offline
Last seen: 15 years 5 months ago
Joined: 2007-09-04 06:23
Safe Eject

Well i ran a preliminary test by remapping the drive letter on the Windows XP machine and i have had no issues picking up where i left off with Apache and MySQL. I am wondering now if perhaps i didnt safely exit MySQL before pulling out the USB key yesterday when i did my initial installation, this would defintely cause the database files to be all borken.

Could be a bit of a pain if you accidentally pull the thing out mid-operation, i wish USB slots had a secuirty pin or something now like the no-open lock on CD drives.

Ill see how i go tonite on the Win2K box and if it works there then i guess its safe to say its just an issue of making sure you cleanly shut down the MySQL Service.

PS This second installation is the same as the first, with all the XAMPPlite files in :\xampplite\...

chillicane
Offline
Last seen: 15 years 5 months ago
Joined: 2007-09-04 06:23
confirmed

Well that confirms it, it was just that i didnt cleanly shutdown MySQL, installation works fine in Win2K.
I would suggest people always properly 'Stop' the USB drive before pulling it out, even on XP as this will tell you if there are still locked files or processes running from the drive.

Log in or register to post comments