Php/Mysql- uploading Mysql database

If you are using something like phpMyAdmin, there is a feature in there to EXPORT your data, including code to create databases/tables as needed before inserting code.

First thing, contact your hosting company, they may have to set up the database for you to use.

Where we have our hosting, they limit how many databases you can have on shared servers, and through their control panel you set up additional databases up to how many you can have for your plan level. If you setup is like this, you will want to export jus the tables and the data, as they will (or their control panel system will) set up the actual database, then you run the script from the export to rebuild all the tables/data.

Which tutorial are you using to do this? (can you poist a link) Just remember, there are tons of tutorials out there, and not all of them are the best/most secure method. It is usually just that the person who wrote the tutorial doesn't know, not that they purposely are giving bad examples. There are many ways to program, but not all cover security issues.

I had run into this when it came to designing a user conrol system, tons of "register/login" scripts, not all of them really good. I compared about 20-25 of them and pulled what I felt was the best secure aspects of each one, also trying to figure out which was the most current tutorials.

Now I'm running into the same with CSS tutorials, finding good ones that are cross browser (standards strick) and that are up to date. Tons of tutorials from people who just know how to make IE look pretty

If you have any more questions, let us know, we'll be glad to help.

-Greg

PS. I moved this to the database forum as that is the more appropriate section.

The server have indeed set up a database, I'm wondering how to get the data (fields, tables, etc.) from the Mysq database I've created locally to the server. I havn't any experiance in mysql/php and I'm just having trouble knowing where to start learning it!

The tutorial is from Web Monkey and the link is: http://webmonkey.wired.com/webmonkey/programming/php/tutorials/tutorial2.html

Cheers

Use the mysqldump command in your mysql bin directory to create a .sql file containing all of the data. You can then import the data from the .sql file to mysql on the new server.

The command goes something like

mysqldump -u (username) (databasename)

See http://dev.mysql.com/doc/mysql/en/mysqldump.html for more

Most of the ISP's that I've used have some flavour of phpMyAdmin running..like a previous poster mentioned. phpMyAdmin gives you a nice front end to easily manage your databases, tables, fields and data without having to be a SQL DBA.