use the following script
##
#!/bin/sh
# Create the temporary copy directory
mkdir /tmp/mysql
# Get the list of MySQL Databases & copy them
for var in `find /var/lib/mysql/ -type d | \
sed -e "s/\/var\/lib\/mysql\///"`; do
mysqlhotcopy -q "$var" /tmp/mysql
done
# Tar/gzip data
date=
Yes , and I done myself to mssql on windows from linux/apache
you have to use odbc .. use FreeTDS , it is free and open soured... and work
like a charm
Nabil
"John Almberg" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Here's a question I hoped I'd never have to ask...
>
> Is it
Yes, it is possible, but you will have to use an odbc connection on the
linux box. I have heard of this being done, but never attempted to
mysql, go to www.iodbc.org, that is the odbc software for linux, lots
of articles on php+apache+odbc there.
--James
On Wednesday, Sep 10, 2003, at 21:55 Am
How about piping the output to a file? As in:
mysqldump [OPTIONS] database [tables] >outfile
Or using the --tab option?
-- John
Jeffrey N Dyke wrote:
http://www.mysql.com/doc/en/mysqldump.html
Here's a question I hoped I'd never have to ask...
Is it possible for PHP, running on a Linux/Apache webserver, to connect
to an Access database running on a remote NT box? The NT box is a back
office server behind a firewall.
In a nutshell, the customer wants his website to be able to record
Now that I see code, I would say just run a 'SELECT * FROM table LIMIT 1' on
your table, and run it through your code. That should give you what you want.
-Micah
On Wed September 10 2003 12:55 pm, Peter Beckman wrote:
> On Wed, 10 Sep 2003, Micah Stevens wrote:
> > describe TBL;
> > explain TBL
Was wondering what are people using to backup their php with MySQL db"s??
Thanks for your time and input..
Aleks.
On Wednesday, Sep 10, 2003, at 16:23 US/Eastern, John Ryan wrote:
Is there any way *from the command line* to get a dump of a mysql
table and
have it saved to a local file, instead of standard output
Have a look at "man mysqldump", particularly the "examples" section.
If you're already dumping th
> Is there any way *from the command line* to get a dump of a mysql
> table and
> have it saved to a local file, instead of standard output
from running mysqldump --help
-r, --result-file=... Direct output to a given file. This option should be
used in MSDOS, because it p
should have read the manual first, mysqldump
"John Ryan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there any way *from the command line* to get a dump of a mysql table
and
> have it saved to a local file, instead of standard output
--
PHP Database Mailing List (http://www.
http://www.mysql.com/doc/en/mysqldump.html
"John Ryan"
Is there any way *from the command line* to get a dump of a mysql table and
have it saved to a local file, instead of standard output
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, 10 Sep 2003, Peter Beckman wrote:
> Then mysql_list_fields didn't work right. So I submitted a bug
> (http://bugs.php.net/bug.php?id=25460) about it, and they said IT TOO was
> depreciated, which is fine. But I haven't figured out how to replace
> mysql_list_fields with a nice simple SQL
On Wed, 10 Sep 2003, Micah Stevens wrote:
> describe TBL;
> explain TBL;
> show columns from TBL;
Yes, they do give the correct information.
However, my question was is there a nice simple SQL command that will
return exactly what mysql_list_fields (now depreciated) so that the
$result can
You have a couple of choices if I remember correctly.. For a table of name
'TBL':
describe TBL;
explain TBL;
show columns from TBL;
-Micah
On Wed September 10 2003 12:08 pm, Peter Beckman wrote:
> So PHP is saying mysql_list_tables is depreciated. I replaced it with
> mysql_query("SHOW TABLE
So PHP is saying mysql_list_tables is depreciated. I replaced it with
mysql_query("SHOW TABLES FROM DB") and everything is fine.
Then mysql_list_fields didn't work right. So I submitted a bug
(http://bugs.php.net/bug.php?id=25460) about it, and they said IT TOO was
depreciated, which is fine. B
>I have a database full of names. each name could be linked to any
number of
>sub-names, each sub-name could be linked to any number of sub-sub-
names, to
>infinity (unlikely but possible).
>
>I need to iterate through this nest of names starting with a main
name; lets
>call the main name Peter.
Here is how I do it ...
[REF PHP PAGE]
. HTMl CODE HERE .
".$instance."\n";
}
?>
. HTMl CODE HERE .
[conn.php]
--
Hope that helps ...
Roy A. Jones
US Pharma Database Administration
GlaxoSmithKline I
eventhough I've never used Oracle with PHP here is my suggestion:
create a file that will have your DB connection strings and include it in
every PHP file which uses Oracle connection.
EXAMPLE:
[dbCon.php] file
[EMAIL PROTECTED]($o_conn_vars["username"], $o_conn_vars["pa
What DBMS are you using? ... Oracle, MySQL or what?
If MySQL then you don't have to make it manual with PHP code (I mean copy
process) .. use something link PhpMyAdmin - there it is very easy to do it.
--
Muhammed Mamedov
Software Engineer
YTM.com.tr
"Jeremy" <[EMAIL PROTECTED]> wrote in messa
Below I include solutions to your problems.
* now I am in Turkey/Istanbul.. I graduated from a University herebut I
am,myself, citizen of Turkmenistan
Muhammed Mamedov
Software Engineer
YTM.com.tr
- Original Message -
From: "Ferry CS" <[EMAIL PROTECTED]>
To: "Muhammed Mamedov" <[EMAI
21 matches
Mail list logo
