phpmyadmin: final stage

[aarushi2001]

Hello,

With the help of this forum, I have learnt alot.

Can someone provide me a tutorial link or help related the following question:

I have mysql running on my local machine. I want to host my website and have got details related to phpadmin from them. How will I export my DB from local to server? Once I do mysqldump and create a backup file, what is the next step?

Thanks

 

[TonyGroves]

mysqldump produces files of SQL commands which will recreate and populate tables. As far as I know, phpmyadmin will allow you to execute that file. You would need to create your empty database first.

 

[aarushi2001]

The database has been created automatically by the the host ppl.. how can I access the *.mysql file through phpadmin???

 

[TonyGroves]

I don't use PHPMyAdmin, but if it can execute external SQL files, I'm sure it would be fairly obvious.

 

[VAMick]

There is a link w/in phpmyadmin for uploading a .sql file.

 

[aarushi2001]

Thanks VAMick..

 

[aarushi2001]

and Tony