FAQ/MySQL

UserPreferences

1. How to I access MySQL from a Python CGI script?
2. MySQL access w/o shell
3. how do I reset an auto_increment column?
4. How do I use mysql from the shell?
5. How do upload an existing mysql database?
6. how can I back up my database if I don't have a shell account?

How to I access MySQL from a Python CGI script?

The Python MySQLdb module is installed. Sample code:

  1 
  2 
  3 
  4 
  5 
  6 
import MySQLdb
db = MySQLdb.connect(host="db.sabren.com", user="username", passwd="password", db="your_db")
cursor = db.cursor()
cursor.execute("select * from table where id = 3")
row = cursor.fetchone()
print row

About the only other thing I needed to know was that the the returned items will be in a tuple if there is more than one, not a list. Good to know if you want to do some post processing of the results. - DominicFitzpatrick

More documentation: http://www.devshed.com/Server_Side/Python/PythonMySQL/

Note: This link appears to be dead or otherwise missing - CharlesLaShure

MySQL access w/o shell

The easiest way to see your database is to log into the web based manager (PHPMyAdmin):

http://db.sabren.com/

Remember to use your DATABASE username and password, not your normal ftp/mail pair.

The other option to ask for remote access, in which case you could connect from the command line MySQL client from home or a GUI tool like Mascon:

http://www.scibit.com/Products/Software/Utils/Mascon.htm

how do I reset an auto_increment column?

ALTER TABLE tbl_name AUTO_INCREMENT = 1;

How do I use mysql from the shell?

mysql -h db.sabren.com -u user -ppassword dbname (dont forget the -h db.sabren.com)

How do upload an existing mysql database?

Use mysqldump.

% mysqldump -h old.db.server.com -u old_user -p old_database > data.sql [enter password]

To reimport into a blank database:

% mysql -h db.sabren.com -u user -p database < data.sql [enter password]

how can I back up my database if I don't have a shell account?

Go to http://db.sabren.com and

• Log in with your DATABASE username and password
• click on the database name (noteitposts_db) in the upper left frame
• click export tab in the right frame
• click select all
• click save as file
• click gzipped
• click "go"