hm
i have to admit that i do not know any other possibility to dump
mysql-tables. but the exec-method is not availiable on every server (because
of security problems). if your system is secure, there isn't _any_
problem...
i though just in case...
btw.: does anyone know a better solution dumping tables than using
mysqldump?
.ma
Lisi <lists@shemeshdirectory.co.il> wrote@25.05.2003 20:24 Uhr:
> Why? Is there a better method? There isn't really any user input, the
> script is set up by the site admin, and run via cron each day. I'm only
> using PHP because I'm not that great with Perl, although I have a feeling
> the script would be pretty similar.
>
> -Lisi
>
> At 11:03 AM 5/25/03 -0400, Becoming Digital wrote:
>>> but using the exec-method seems very dangerous to me...
>>
>> I'll second that.
>>
>> Edward Dudlik
>> Becoming Digital
>> www.becomingdigital.com
>>
>>
>> ----- Original Message -----
>> From: "heilo" <grillen@abendstille.at>
>> To: "PHP-DB" <php-db@lists.php.net>
>> Sent: Sunday, 25 May, 2003 06:24
>> Subject: Re: Using variable in variable name
>>
>>
>> Use the string-operator .
>>
>> if i understood your code right:
>>
>> exec('mysqldump -uroot --opt $db $show_a[Tables_in_$db] >
>> ..\admin\dbbackups\' . $show_a[ 'Tables_in_' . $db ] . '.sql');
>>
>> but using the exec-method seems very dangerous to me...
>>
>> .ma
>>
>> Lisi <lists@shemeshdirectory.co.il> wrote@25.05.2003 12:45 Uhr:
>>
>>> I am writing a script to backup tables in a specified database. I first
>>> execute a query to get a listing of table names in that db(show tables).
>>> Then I loop through the results one row at a time, using exec to pass the
>>> name of the table to mysqldump.
>>>
>>> The problem is that the database name is defined in a variable at the top
>>> of the script, like so:
>>> $db = "DB";
>>>
>>> The variable $db is then used in the query, and the subsequent exec call
>>>
>>> $show_q = "SHOW TABLES FROM $db";
>>> $show_a = mysql_fetch_array($show_r);
>>> $show_rows = mysql_numrows($show_r);
>>>
>>> for ($i = 0; $i < $show_rows; $i++) {
>>> $show_a = mysql_fetch_array($show_r);
>>> exec("mysqldump -uroot --opt $db $show_a[Tables_in_$db] >
>>> ..\admin\dbbackups\\$show_a[Tables_in_$db].sql");
>>> }
>>>
>>> But I am getting a parse error for Tables_in_$db - how do I correctly use
>>> the variable $db within the variable $show_a[Tables_in_$db]?
>>>
>>> Thanks,
>>>
>>> -Lisi
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>
Matthias Steinböck
Email: grillen@abendstille.at
Web: http://www.abendstille.at
Frühabendliches Webdesign.
------------------------------------------
Im Übrigen sind wir der Meinung, dass
Die Monarchie die einzige mögliche
Staatsform ist (Solange wir den König
Stellen und absolut herrschen).
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
