Transfering MySQL dump file ON hosting server

[MacCoilin]

Hello,

I have changed hosting companies. I have a database table with almost 100,000 records. It's about 11 MB in size.

With the new hosting company I....

1) do not have Shell access to run MySQL dump, and

2) I do not have FTP access to the database folder.

PHPMy Admin will not transfer the sql file of this size.

Does anybody know of a php script method to transfer the table contents on the database on the server?

In other words is it possible to transfer via FTP a sql dump file into my web space and then run a php script that will write the contents to the database?

I could split the the dump file into sizes that PHPMyAdmin could handle but that would be time consuming at the moment.

Any thoughts appreciated.

Brian MacCoilin

[nnichols]

Do you have external access to the db server or is it restricted to localhost?

[MacCoilin]

Hello,

Thanks for the reply. It is set up for local host.

I could create an XML copy of the table and write a php script to parse it and write to the mysql database on the hosting server but I wanted to see if there was a recognised way of dealing with the issue.

Thanks,

Brian.

[nnichols]

I would suggest creating a simple php script to output all the data for the tables as a file and store it within your web-tree so you can download it with your ftp client. It is easy to do and easy to read back in when your done.

You don't need to create an XML copy - why would you want to?? It would simply lead to an oversized/overcomplex dumpfile.