how to upload mysql database to my serverspace in programming

[neelsbr]

how to upload mysql database to my server space (hostgator,blue host) in programming method.any one can help me to do this.


Thanks in Advance

[code green]

mysqldump to produce a SQL file
FTP the SQL file.
Run the SQL on the server space

[neelsbr]

How to run sql in server space.suppose i runs ,if any changes to be done in my database

[code green]

You run files and maintain a database on a remote server the same as you would locally.
The remote scripts can be run through a local browser or on a Cron/Sched Task remotely

[neelsbr]

thanks for your reply.i am using select out file query export data in my local system and load data in file query to import data.i m connecting to server from my local system.load data infile query is not executing.data are not imported in my server database.but that load data infile query works in my local system.can you please help me .

Thanks

[code green]

'Is not working' is not very helpful.
There could be a multitude of reasons depending on your set-up.
You need to check whayt erors are being returned

[neelsbr]

no errors would returned.load data infile query is not working.i checked that.i give the correct path,where i stored the sql file.this is the path i given backup/$table[$i].sql.table name comes automatically it runs through the loop

[neelsbr]

i find out the problem.i want to get the sql file from mysql/data/backup/table1.sql.My programs under( htdocs/test/test.php).htdoc s directory.Now please help me to access that file.If i can access that file then ,the query will work.

Thanks

[code green]

I don't understand which file you are trying to access or from where.
Do you mean you want to run test.php?
Or do you mean you want test.php to run the .sql file.

From where are you running these scripts, on the server itself or remotely.

Either way what do you mean by

Now please help me to access that file

[neelsbr]

I am running test.php to execute a sql file.i am running program in my local system.please help me to how to access that particular file in my local system. sql files comes under this path C:\xampp\mysql\ data\backup.i want access the sql file in the above path.i understand the problem .the path is not given correctly.
thank u