mySQL
Posted by: Tsango (---.ontanet.managedbroadband.co.uk)
Date: September 13, 2006 10:02AM

Hi there

Need help....!

I have WAMP 5 installed and that is working fine, but I now want to use mySQL with PHP.

Do I need to install mySQL seperatly or is it already included in WAMP?

SQLite appears to be installed so if this is all I need then how do I create databases and tables and then manage them? Is there a manager to do this?

I do know SQL so I don't need to know the syntax's ect, I just need to know where it is done and how the databases/tables are managed.

Any help gratefully recieved...!

Regards

Oliver

Re: mySQL
Posted by: trixterj (---.30.118.70.cfl.res.rr.com)
Date: September 13, 2006 11:05AM

use PHPmyAdmin,
its installed, you can install it as a service (I prefer it).

You can click WAMP (taskbar button) and go to MySQL and see if its running,
also you can get into MySQL by the Console, but again PHPmyAdmin is the
way to go. Your password for MySQL might be "root", I am unsure of the default
settings for it right now.

Re: mySQL
Posted by: Tsango (---.ontanet.managedbroadband.co.uk)
Date: September 13, 2006 04:42PM

Thanks - I have just worked out PHOPmyAdmin and managed to create a database and some tables.

Two further questions.

1. Where are the databases stored?
2. How do you upload them to the server and where do they reside?

Thanks

Oliver

Re: mySQL
Posted by: metaclark (---.genericrev.cantv.net)
Date: September 14, 2006 03:30PM

I need some help here Yesterday I was working really well with wamp and today It just starts PHP and MySQL doesn´t work. Please help me with this one

Re: mySQL
Posted by: Serving the King (---.syracuse-02rh15-16rt.ny.dial-access.att.net)
Date: September 16, 2006 12:24AM

For Oliver:

Q: 1. Where are the databases stored?

A: On your local system find where the WAMP main folder is. For my system it is in c:\wamp\

In the WAMP directory is a folder labeled "MySQL". Inside that folder is a another folder labeled "data" and that is where you will find the folder that contains your database tables.

So it should be c:\wamp\MySql\data\your_site_folder

Q: 2. How do you upload them to the server and where do they reside?

A: I have no idea. I just got this myself the other day, so I'm still working on it.

STK

Re: mySQL
Posted by: Serving the King (---.syracuse-02rh15-16rt.ny.dial-access.att.net)
Date: September 16, 2006 12:29AM

For Metaclark:

When you start WAMP there should be an icon for it in the System Tray. Left click on that and look for the link that says "Start All services." That should start MySQL service for you. This is not the MySQL program, just starts the service.

To access the MySQL program, left click on the system tray WAMP icon and go to the top of it looking for the PHPMyAdmin and click on it. That will start the MySQL program for you, if it is installed.


STK

Re: mySQL
Posted by: roms (---.fbx.proxad.net)
Date: September 16, 2006 12:31AM

Use phpmyadmin to export your local databases.
You shoiuld also have a phpmyadmin on your server, use it to import your database.



Romain

Re: mySQL
Posted by: CyberSpatium (67.170.181.---)
Date: September 16, 2006 12:51PM

remember when you use phpmyadmin to export your database to export your tables and all your data. then use your webhosts phpmyadmin to import your tables and data and your ready to go

Sorry, only registered users may post in this forum.