Uploading DATABASE to WEB Hosting.

[nouck]

Hi,

 

Does anyone know how to upload the .sql database to web hosting provider? They are using phpmyadmin, and there already database created there with no tables. I would like to upload my database to the server, or just import it to the emtpy table database wich already created there. Any idea?

 

 

Thanks.

 

nouck.

[mattice]

In the downloaded package there is a file called oscommerce.sql

You should import that with phpMyAdmin on the database (or create a new one called 'catalog')

 

Can't you use the standard installer? Or are you using 2.1?

[nouck]

I am using the version 2.2. I have done everything locally. Have modified some of the data fuction and strings.

 

Also, i have already keyed in the products.

[mattice]

In the admin side (locally) look under tools. You can create a backup there.

It will tell you where the backup is stored. This backup is an SQL file.

Upload it to phpMyAdmin and all should go well. If the script times out (ie it takes longer to do the insertions that script execution time is set) you will get an error and you should do it directly in mySQL (commandline) or do it in parts... which can be a pain.

 

HTH

Mattice

[Guest]

What you have to do is dump your current db by going to the admin page>tools>database backup

 

choose no compression and then choose download only

click backup, windows will then ask if you want to save the file (the file might have a php extension, don't worry) just save it to disk.

 

now load up phpmyadmin on your host and select the catalog db.

scroll down until you get to run sql queries and click on browse

select the db file you saved in the last step and click go

 

You will loose all data in the db on your web server by doing this. but all the data from your localhost server will be imported

 

Ryan

 

PS you might have to create a backups directory under your admin directory for the database dump to work

[nouck]

Thanks for all the replies.

 

:-))

 

I used mattice instruction by doing a new install, instead of using oscommerce.sql, I copied my database.sql over the oscommerce.sql to overwrite the file. Now, durring the new install, I will actually have my database. :-)) My database is 1.9megs, and no problem of uploading it.

 

Hopefully, this can help others who have same question.

 

Nouck