Archives > Technical Support
SQL help
btraill:
That's a pretty big assignment and I'm just about to head out.
This webpage may contain a decent amount of info that will help: (Contains database tables/examples for a Hangman game)
http://docstore.mik.ua/orelly/apache_mod/59.htm
Coach:
--- Quote from: btraill on December 01, 2012, 10:24:19 pm ---That's a pretty big assignment and I'm just about to head out.
This webpage may contain a decent amount of info that will help: (Contains database tables/examples for a Hangman game)
http://docstore.mik.ua/orelly/apache_mod/59.htm
--- End quote ---
Thanks for the website that may help. If you can find any time before tuseday at midnight to do it i will be willing to pay you via paypal.
Also how do i just export a data base so i can submit my work.
btraill:
Export as in just save as a .sql file? How are you doing this? In the assignment it said to use a hosting account -- is that what you are using? If so, most hosting admin panels include a MySQL option where you can see all your tables. There should be a button to export any of them into a .sql file.
Coach:
right now im doing back assignments and im just in mysql 5.5 command line client.
btraill:
Well.. Exporting via SSH or a command line try this:
mysqldump -u USERNAMEHERE -p PASSWORDHERE DATABASE > FILENAMEHERE.sql
Make sure the user you are using/logging in has root or high enough permissions to read/write from the current database or table you are working in.