uploading tables from wamp

[jebo100]

hello everyone,

i have been working on a test project in wamp.
and now i am trying to run it online.
i already uploaded all the html and php files and its now up and running except the databases.

my question is, how do i upload my mysql databases or tables?
on what directory should i put the mysql files?

thanks in advance!

 

[TonyGroves]

You would create and populate your tables by using SQL commands, or by using a graphical front-end like PHPMyAdmin.

You shouldn't need to think about where the data files are stored; all database access is done via SQL.

 

[jebo100]

tony,

to clarify, i have develop all my php codes and mysql db & tables on my localhost (my hardisk) using WAMP.

and now i wanted to upload this files to a webhost which is bravenet in my case. i can upload all my php and html codes without problem, but i'm lost when it comes to uploading the db and its tables. where should i put this db's?

what i am trying to do now is to re-create the db and tables on my webhost's mysql server.(which i think would be impractical because i have about 15 tables on my db)

thanks for the feed back,

 

[vacunita]

I'll repeat what I said in the PHP forum where you first asked this question:

You need to create a dump of your DB and feed to your online DB. Your webhost should give you a way to access it. Probably through phpmyadmin or something similar.

For starters use the mysqldump.exd on your database, so it creates a file you can then use to recreate your DB on your host.

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

The dump will be a series of commands CREATE, INSERT, etc. that will tell your Webhost's database what it needs to do to recreate your DB.

Now as was said before, using PHPmyadmin or whatever your webhost provides to access the DB. you can feed the file created by mysqldump to it and have it recreate your DB there.


----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[jebo100]

vacunita,

thanks a lot for help.
i really appreciate that.


thanks again friends