To talk on Icrontic, just register!

It only takes 30 seconds.

Have an account? Sign in:

Forgot?
 
Reply to Discussion Options
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 4:38pm

Question MySQL Help

Last night was was messing around with apache and i got PHP and mySQL installed so then i put up a forum just to see if it would work. the forum worked and everything was fine. so i shut down my computer cause the parentals are evil and went to bed. when i woke up and started it up apache started fine, but mySQL looks like i lost all my databases and it can't seem to find the server. any ideas?
__________________ [folding_sig2]
Reply with Quote
-tk
incorporate
-tk
386 Posts
4 Jun 2003, 5:07pm
what platform are you running this stuff on? *NIX or Windws?
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 5:18pm
windows XP pro. i'm not sure if MySQL can find the server or not...
Attached Thumbnails
Click image for larger version Name: 1.jpg Views: 58 Size: 109.2 KB ID: 99  
Reply with Quote
Enverex
~-+-~
Enverex
5,852 Posts
4 Jun 2003, 5:34pm
Its not finding the server, otherwise the boxes on the right would be filled in.

Go into Windows Services and make sure the service is actually running.

NS
__________________ RetroTracks - Classic Computer and Game Music
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 5:38pm
ok i got it where it finds that server now. but mysql is using 312 MB of my memory how can i fix that?
Reply with Quote
-tk
incorporate
-tk
386 Posts
4 Jun 2003, 5:39pm
well, I've never installed mysql and apache on windows before, so I'm kid of in the dark, but a few things to check:

does mysql start at bootup?
is it started now?
Reply with Quote
-tk
incorporate
-tk
386 Posts
4 Jun 2003, 5:46pm
MyNewName5333 said
ok i got it where it finds that server now. but mysql is using 312 MB of my memory how can i fix that?
I dont know if the windows version has it, bet there shoudl be a file someplace called my.cnf where you can set all that stuff
Reply with Quote
Enverex
~-+-~
Enverex
5,852 Posts
4 Jun 2003, 5:55pm
Strange, my MySQL server sometimes takes moderately large loads and it never seems to go about about say 5MB or so, and its using less sat here now. Not changed it since install.

NS
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 6:36pm
i fixed the memory problem, i just had to change the my.ini file. but i still can't seem to get MySQL to work. it says its running ok, but i get this error when i try and go to my forums

http://68.86.145.46/forums/

any ideas on that? lol
Reply with Quote
Enverex
~-+-~
Enverex
5,852 Posts
4 Jun 2003, 6:42pm
Go onto the Databases Tab on MySQL admin and make sure you have named the Database right, it may not have been called "invision".

NS
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 6:45pm
yep its called invision
Attached Thumbnails
Click image for larger version Name: dt.jpg Views: 44 Size: 117.9 KB ID: 109  
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 6:50pm
heres the invision board setup... i copied the invision folder and pasted all the files in a folder called 1 to see if it would work that way.
Attached Thumbnails
Click image for larger version Name: dt2.jpg Views: 41 Size: 177.3 KB ID: 110  
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 6:51pm
and here's the error i get...
Attached Thumbnails
Click image for larger version Name: dt3.jpg Views: 41 Size: 47.1 KB ID: 111  
Reply with Quote
Enverex
~-+-~
Enverex
5,852 Posts
4 Jun 2003, 7:38pm
You put the SQL database name as "1".

Change it to "invision"

NS
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 8:26pm
i know, i tried it that way to make sure something wasn't wrong with the "invision" folder. i took all the files from invision and moved them into "1". but that doesn't matter, because it does the same thing if you put invision as the database name.
Reply with Quote
Enverex
~-+-~
Enverex
5,852 Posts
4 Jun 2003, 8:32pm
Try not entering anything for the username and password.

NS
Reply with Quote
AuthorityAction
AA
AuthorityAction
481 Posts
4 Jun 2003, 9:14pm
i logged in as root and no password and it let me in. thanks for your help NS and -tk.
Reply with Quote
Go Back   Icrontic Forums > Tech: Software > General Software
Reload this Page MySQL Help
Jump to
This Thread Search this Thread
Search this Thread:

Advanced Search

Today's Posts - Mark All Read - Contact Us - Icrontic.com - Archive - Top

Current time: 1:54am (GMT)
Powered by vBulletin®
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Get Vanilla instead. Trust me.