MYSQL database uploading
Posted 07 March 2003 - 12:34 PM
I am having problem in uploading \"MYSQL database tables\" from my hard drive to a web site.
I am given with username and password and also database availability.
Please give me comments to solve this problem.
Baber N. Abbasi
Posted 07 March 2003 - 02:40 PM
Posted 07 March 2003 - 03:14 PM
Please baber, tell us what the question is.
Do you not know who to make the backup?
or are you getting errors while trying to back up.
Posted 08 March 2003 - 06:36 AM
The problem I am having is I never uploaded MYSQL fucntioned site before. You can say its new to me to upload database driven site having MYSQL support.
What I want to know is how should my databse including tables and their data will be loaded on the site.
I hope now the problem is explained in detail and do let me know if it\'s not clearer to you.
Please help me solve this problem.
Posted 08 March 2003 - 11:44 AM
Once in there you can manage all of your tables instantly!
To do what you are saying in uploading a table with data then you can simply copy and past the text inside the .sql file into phpmyadmin or upload the file! It will then run and bingo you have your database up :-)
Posted 08 March 2003 - 12:12 PM
Thanks for ur help.
Phymyadmin is installed on the web site. Tell me how should I upload table already created in MYSQL. Should I need to copy and paste and database files from the hard drive or I have to write sql commands in my script.
Posted 08 March 2003 - 01:01 PM
When the new page loads go to SQL
You will see a large text box either paste the contents of .sql file into there (open the file with notepad) or clcik on browse and select the file from your hard drive! then clcik run! It will then execute the commands in the .sql file and install the tables and data into your databse!
PS would be wise to back up any of your databses jsut in case you make a mistake
Posted 11 March 2003 - 11:31 AM
I am going to upload my web site and it uses some tables. Please tell me how should I create these tables at my hosting server.
I think it is more clearer.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users