phpmyadmin question

Anon

I am attempting to publish a PHP/MySQL site for the first time. I have everything running correctly on my local machine. I assumed that I could create all my tables locally and then upload them (ftp) them to the proper directory on the site.

I just found out that with the web host provider I chose, I do not have any write permissions to the directory where they store the tables. I do use phpmyadmin on my local machine and the web host provider provides phpmyadmin also.

My question is can I still create my table on my local machine and them upload them somehow using phpmyadmin? What is the best way for me to get the table data to the server?

David

Anon

Create them locally and then get the structure schema from your local phpMyAdmin and run that schema query on the providers machine to create the tables there.

Anon

interested in how to upload the table data than just creating the tables. I have all my table data on an excel spreadsheet and load my table by saving the spreadsheet as an .csv file. Would I then just have to load that file twice - once on my local machine and another on the server? One of my tables will be approx 200,000 records where I will have to do in sections anyway.

David

Anon

You have the option in phpMyAdmin to dump the schema alone or the schema and data.

Most DBMS's allow for dumping your data into text files. You just need to make sure your field and row delimiters are proper.

Anon

saying. It is probably not quicker to dump the data and reload on the server but that way would prevent me from having to keep two different location of the same table updated. I could see where after awhile the data in the two different tables would not be the same unless I do it the way you are suggestng. I will just have to see how dumping 200,000+ records work as that is my largest table at this time.

David