Forum Moderators: coopster
Is it possible to create a script on my paid hosting to access a MySQL db I am running on my home pc and import it in to the paid host MySQL db?
Also what's the deal with PHP v5, is it true that it's not going to support MySQL anymore? :/
Thanks
Chris
Regarding your first question:
It is possible, but I wouldn't recommend it because it brings some security issues with it. If you really need to do it this way, then ask me again. I would recommend creating a dump of your local database and importing it into your hosted database. That should be the cleanest solution without any additional risk.
To your 2nd question:
PHP5 doesn't have built-in support for MySQL. But you can still use it together using the open source linking possibilities. So no need to worry about it.
So long...
CT
Helpfull advice.
Chris :)
As far as I know, it's just the beta's of PHP5 that don't have the Mysql libraries built in but they're optimisic about resolving it in time for the real release. Still, if anyone's got any more information about it then it would be good to know :)
phpMyAdmin is indeed a good solution for small databases. But when they get bigger than certain sizes (I don't know exactly where, but I had the problem sometimes) it can't import them anymore or you would have to change the script run time. So the dump im- & export is the safest bet. But as I said, if it is just something small and you have installed phpMyAdmin anyways, than this solution is easier.
A link regarding the MySQL support is the changelog of PHP5
[php.net...]
They had to get rid of the built in MySQL support due to licensing issues. But it's still possible to link to the libraries supplied by MySQL.
So long...
CT
The actual sql commands to look at would be
SELECT .. INTO OUTFILE [mysql.com]
LOAD DATA INFILE [mysql.com]
mysqldump, Dumping Table Structure and Data [mysql.com]
