Re: Creating MySQL Databases

[Sarah Reichelt]

I'm just starting a project using MySQL for the first time.  Having 
looked at the Rev 2.5.1 documentation, I'm happy enough that I can 
access and update MySQL databases as required.  However, what I can't 
see is how I can create and carry out basic administration of NEW 
databases.

Hi Peter,
Here is my script for creating a new database. It connects directly to 
the "myslq" database as root (or any user that has the right 
privileges) and sends the create database command to that. I have only 
done it on a local database, so you will need to change the value for 
dbAddr.

I don't know how to rename a database, but if you can find the SQL 
command to do it, then I would hope that this technique would work for 
that as well.

Cheers,
Sarah
on mouseUp
  put "root" into dbUser
  put "mysql" into dbName
  put "localhost" into dbAddr
  ask password clear "Enter root password:"
  if the result = "Cancel" then exit to top
  put it into dbPass
  put revOpenDatabase("MySQL",dbAddr,dbName,dbUser,dbPass) into dbresult
  if dbResult is not a number then
    answer error dbResult as sheet
    exit to top
  end if
  put dbResult into dbID
   ask "Enter the name of the new database:"
  if the result = "Cancel" then exit to top
  put it into newDB
  put "CREATE DATABASE " & newDB into dbSQL
  revExecuteSQL dbID, dbSQL
  put the result into sqlResult
  if sqlResult is a number then
    answer information "Database " & newDB & " created." as sheet
  else
    answer error sqlResult as sheet
  end if
  revCloseDatabase dbID
end mouseUp
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution