phpMyAdmin

Frank Peavy wrote:
> I have numerous ??.sql files that create and insert data into MySql.
> Can I batch some of these so that I can run them sequentially?
> 
> I thought I read that phpMyAdmin can do batch queries. How is it done?
> Thanks.

Using the cfgUploadDir feature, documented in Documentation.html,
you will can upload the .sql files with ftp, then see them in a
drop-down menu of phpMyAdmin to run them.

Marc Delisle

Marc,
Can I create a single .sql file that calls the other .sql files, so I don't 
have to run them
manually, in sequence?

Also, you mentioned the documentation.html, could you provide a link.
I looked everywhere and couldn't find it...

Thanks.


At 01:00 PM 1/6/03 -0500, Marc Delisle wrote:
>Frank Peavy wrote:
>>I have numerous ??.sql files that create and insert data into MySql.
>>Can I batch some of these so that I can run them sequentially?
>>I thought I read that phpMyAdmin can do batch queries. How is it done?
>>Thanks.
>
>Using the cfgUploadDir feature, documented in Documentation.html,
>you will can upload the .sql files with ftp, then see them in a
>drop-down menu of phpMyAdmin to run them.
>
>Marc Delisle
>
>

Frank,

Apart from the solution of creating yourself with an editor a big .sql
file, I don't see a way to do it in current phpMyAdmin version.

The file Documentation.html is included in your phpMyAdmin kit,
and the latest development version is at
http://www.phpmyadmin.net/documentation/

Frank Peavy wrote:
> Marc,
> Can I create a single .sql file that calls the other .sql files, so I 
> don't have to run them
> manually, in sequence?
> 
> Also, you mentioned the documentation.html, could you provide a link.
> I looked everywhere and couldn't find it...
> 
> Thanks.
> 
> 
> At 01:00 PM 1/6/03 -0500, Marc Delisle wrote:
> 
>> Frank Peavy wrote:
>>
>>> I have numerous ??.sql files that create and insert data into MySql.
>>> Can I batch some of these so that I can run them sequentially?
>>> I thought I read that phpMyAdmin can do batch queries. How is it done?
>>> Thanks.
>>
>>
>> Using the cfgUploadDir feature, documented in Documentation.html,
>> you will can upload the .sql files with ftp, then see them in a
>> drop-down menu of phpMyAdmin to run them.
>>
>> Marc Delisle
>>
>>
> 
> 
>

Running the current version of phpmyadmin on OS X, I can not seem to
understand how to secure it other than using .htaccess, I do not like my
username and password in plain text in the config file, can someone please
explain to me exactly what I have to do to make this work, the docs are a
little confusing to me, I am on OS X

thanks

-------------------------------------------------------------
Scott Haneda                                Tel: 415.898.2602
http://www.newgeo.com                       Fax: 313.557.5052
scott@...                            Novato, CA U.S.A.

In the documentation that you linked to this message, you will notice under 
Introduction the following:

* execute any SQL-statement, even batch-queries

My question is, how do I batch queries... ?
Its a feature, someone must know...


At 01:25 PM 1/6/03 -0500, Marc Delisle wrote:
>Frank,
>
>Apart from the solution of creating yourself with an editor a big .sql
>file, I don't see a way to do it in current phpMyAdmin version.
>
>The file Documentation.html is included in your phpMyAdmin kit,
>and the latest development version is at
>http://www.phpmyadmin.net/documentation/
>
>Frank Peavy wrote:
>>Marc,
>>Can I create a single .sql file that calls the other .sql files, so I 
>>don't have to run them
>>manually, in sequence?
>>Also, you mentioned the documentation.html, could you provide a link.
>>I looked everywhere and couldn't find it...
>>Thanks.
>>
>>At 01:00 PM 1/6/03 -0500, Marc Delisle wrote:
>>
>>>Frank Peavy wrote:
>>>
>>>>I have numerous ??.sql files that create and insert data into MySql.
>>>>Can I batch some of these so that I can run them sequentially?
>>>>I thought I read that phpMyAdmin can do batch queries. How is it done?
>>>>Thanks.
>>>
>>>
>>>Using the cfgUploadDir feature, documented in Documentation.html,
>>>you will can upload the .sql files with ftp, then see them in a
>>>drop-down menu of phpMyAdmin to run them.
>>>
>>>Marc Delisle
>>>
>>
>
>

You can remove the username and password from the config file, and put
'cookie' in the auth type.

Which part of the doc is confusing?

Scott Haneda wrote:
> Running the current version of phpmyadmin on OS X, I can not seem to
> understand how to secure it other than using .htaccess, I do not like my
> username and password in plain text in the config file, can someone please
> explain to me exactly what I have to do to make this work, the docs are a
> little confusing to me, I am on OS X
> 
> thanks
> 
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> http://www.newgeo.com                       Fax: 313.557.5052
> scott@...                            Novato, CA U.S.A.
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpmyadmin-users mailing list
> Phpmyadmin-users@...
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users
>

Scott:

The easiest thing to do is use cookie authentication instead of config.
Then you can remove the the user name and password from the config file.
Here's the line from my config file:

$cfg['Servers'][$i]['auth_type']     = 'cookie';    // Authentication
method (config, http or cookie based)?

Now phpMyAdmin will ask for a a user name and password when you log in to
phpMyAdmin.

By the way, I'm using OS X without any problem--except that IE doesn't
highlight rows properly. Try using Chimera as your web browser. It's much
faster and works better with phpMyAdmin.

Jay Davis
Atlanta, GA USA

----------
Recursive, adj.; see Recursive

On Mon, Jan 6, 2003, Scott Haneda <lists@...> wrote:

>Running the current version of phpmyadmin on OS X, I can not seem to
>understand how to secure it other than using .htaccess, I do not like my
>username and password in plain text in the config file, can someone please
>explain to me exactly what I have to do to make this work, the docs are a
>little confusing to me, I am on OS X
>
>thanks
>
>-------------------------------------------------------------
>Scott Haneda                                Tel: 415.898.2602
>http://www.newgeo.com                       Fax: 313.557.5052
>scott@...                            Novato, CA U.S.A.
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:ThinkGeek
>Welcome to geek heaven.
>http://thinkgeek.com/sf
>_______________________________________________
>Phpmyadmin-users mailing list
>Phpmyadmin-users@...
>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-users

I just added this in Documentation.html:

"Even in a single-user environment, you might prefer to use http or cookie mode so that your user/password pair are not in clear in the configuration 
file."

Marc

Gurufish wrote:
> Scott:
> 
> The easiest thing to do is use cookie authentication instead of config.
> Then you can remove the the user name and password from the config file.