Re: Creating MySQL Databases

Thanks Trevor, I have located and downloaded a copy. Cheers Peter On Mar 20, 2005, at 4:05 PM, Peter Reid wrote: You mention Trevor's libDatabase - where can I get hold of this, it could be very helpful? All of my Revolution resources are available here:

Re: Creating MySQL Databases

On Mar 20, 2005, at 4:05 PM, Peter Reid wrote: You mention Trevor's libDatabase - where can I get hold of this, it could be very helpful? All of my Revolution resources are available here: The posted version is 1.4.5. One of these days I am going

Re: Creating MySQL Databases

Hi Mark Just the job thanks! I had assumed that revDataFromQuery had to be used with table results rather than for general purposes - my mistake!! Cheers Peter Hi Peter, revDB offers three methods of executing SQL commands: 1) revExecuteSQL 2) revQueryDatabase 3) revDataFromQuery revExecu

Re: Creating MySQL Databases

Hi Peter, revDB offers three methods of executing SQL commands: 1) revExecuteSQL 2) revQueryDatabase 3) revDataFromQuery revExecuteSQL should be used when the SQL statement you are executing does not return any data - e.g. CREATE DATABASE, CREATE TABLE, UPDATE etc. - in this case the value

Re: Creating MySQL Databases

Hi Mark Thanks for the detailed response and explanation, it makes things a lot clearer. However, I can't see how I can get non-query results back from the MySQL server. In particular, I want to get a list of current databases, but when I use (from Sarah's suggestion): put "root" into dbUse

Re: Creating MySQL Databases

Hi Peter, The client/server aspect of MySQL and similar databases is all encapsulated in the revOpenDatabase function - and there is no difference utilising the database functions whether you specify 'localhost' as the address or an IP address of a remote machine - the underlying database librarie

Re: Creating MySQL Databases

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

Re: Creating MySQL Databases

Peter- Here's what I do (extract) to create MySQL databases from within runrev. Send the commands to a text file, then execute the MySQL client using the text file as a command script: on CreateDatabase local strFileName, myError -- CreateDatabase asks for a name for the temporary output fil

Re: Creating MySQL Databases

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, He

Re: Creating MySQL Databases

Peter, I recommend that you check your SQL database documentation for there are SQL function for creating databases and stuff like that. phpMyAdmin does nothing but serve as front-end for the MySQL system, all it does is to pipe commands to the server. I'll sum some URLs below that point to goo

Re: Creating MySQL Databases

Peter, I recommend that you check your SQL database documentation for there are SQL function for creating databases and stuff like that. phpMyAdmin does nothing but serve as front-end for the MySQL system, all it does is to pipe commands to the server. I'll sum some URLs below that point to goo

Creating MySQL Databases

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. My project i