I know this probably has an obvious answer, but I am not a db expert. Say I have the db name, db username, db pass, and know it is on "localhost" & I have a sql txt doc how can I get it into a mySQL db if I do not have a php myadmin to access? Is there a script I can get from somewhere in php that I can input the login info and the query (without needing a lot of programming skills), upload to the server, then execute from my browser and it will put the data into the db? Thanks for the help in advance!
Try using a manager like Navicat: http://www.navicat.com/ As long as you have the correct permissions, you can use it to manage a database, and it is much better than phpmyadmin. They have a free trial and a free personal version.
Comusher, Is the MySQL database hosted? If so, your host should have a MySQL manager available. Worst case, you can write a small PHP script to connect to the database, insert the data, and close connections. There are tons of examples on the web to do the above ... and I can assist if needed. Good luck. Social.Network
Thanks for the tips! I will try the Navicat and if that does not work I will try my hand at writing a script.
You can also use MySQL GUI tools such as MYSQL Administrator and MYSQL Query Browser. These applications are developed by MYSQL itself.
You can also use Shell/SSH's command SQL dump. You probably don't know SSH so it may be hard but it is pretty easy...you'll need software for your PC to connect called Putty. You upload file on your server and just dump it directly into your db from there using a shell command. Search google for it.. Or you can use a php script: http://www.ozerov.de/bigdump.php This may be easiest option for ya. It's a script that will run from front-end. It's not a control panel add-on or server application.
if you have console access you can just issue the following command mysql --username=yourusername --password=yourpassword -D yourdatabasename > importfile.sql