XAMPP setup preconfigured for IntegraMOD.

[Fubie]

Is the XAMPP folder in the root of your drive.

C:xampp

[ayasha]

yes, when i click the MySqyl start button i get the error in that screen shot

ERROR: My Sql service not started [-1]

[ayasha]

it has been in the root of the C: and the root of D:

it worked 1 time, i closed it out, restarted my computer, washed a sink full of dishes, came back, started the program again, and got all these errors

[Fubie]

Ok, you may need to backup, Can you un wash the dishes and start it? <img> I wish it were that simple.

Wow, it's really strange that it worked once. Can you try clicking the "run as a service" box for mysql?

[ayasha]

Did you click the MySql start button?
All the other reports are just telling you MySql has not started.

I know is was a stupid question but I once spent an hour fixing something and then realised I forgot to plus it in <img>

Did the 140 install go smoothly?

Click on Settings in the small xampp window and make sure MySql is checked.

i clicked on the Settings and MySql is not checked, i checked it but it makes no difference. it is like it will not keep the tick on MySql.

[ayasha]

[quote=""Fubie";p="1314""]Ok, you may need to backup, Can you un wash the dishes and start it? if i could turn back time i would, wish i had not even messed with those dishes now, housework distracts me too much from IM <img>

where is the "run as a service" box?

Fubie, Mike, either one of you ever do the remote access thing? i am pulling my hair out here, i know it was wierd that it worked once, and usually if i mess something up, after uninstalling, then reinstalling all is well, but nothing i do seems to help.

[Fubie]

To the left of the start button for mysql "Svc"

[ayasha]

that did it Fubie <img> thank you so much, don't know how that box got ticked, but unticking it seems to have worked.

now my only question is, what is the best way to set up your database, bigdump or mysqldumper?

[Fubie]

The simpler of the 2 is big dump. But I prefer sqldump because it backs up as well.

[ayasha]

ok, got the database created, how do i get the tables in it? sorry i am being such a pain this morning guys <img>

[Fubie]

We are all glad to help.

Place your db file in the htdocs folder with your edited bigdump.php file. then run bigdump.php in your browser.

[ayasha]

sorry, but i do not understand that. i used the mysqldumper to create my database.

i do not have a bigdump.php file in my htdocs folder.
in the mysqldumper folder, i have a dump.php file. do i put my database (psp.sql file) in the mysqldumper folder?

[Fubie]

ok, if you used mysqldumper to backup your db, just use it to import the db into a new sql db.

In mysqldumper on the left select the sql db you want to import to.

Then goto restore in mysqldumper.

Select the db file you want to import.

Hit restore.

It will give you a popup. Make sure the info is what you want.

Hit ok.

Sit back and wait.

[Fubie]

Additional question. You used mysqldumper on your host to backup?

[ayasha]

i did not use mysqldumper to back up my database, i did not know it was available to use on the server i was on, as far as i know it was not.

i saved my database as an sql file to my hard drive before i had to move everything to a new hosting.

so is it even possible for me to use mysqldumper?

i edited the bigdump.php file to include the db name, user name, and pw. what would be the path i used to run that?

and then could i back it up with mysqldumper?

how would i get and use mysqldumper on my server?