Re: Backing up all MySQL DBs

2003-09-10 Thread Jerry M. Howell II
directory only part I'd add it the date apended to the filename. Just incase you need to restore a backup from a week ago instead of just yesterday. -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

2003-09-06 Thread Jerry M. Howell II
='root'; Here is the response I get Query OK, 0 rows affected (0.01 sec) Rows matched: 4 Changed: 0 Warnings: 0 Not sure why nothing is changed? Anyideas. Might root not have the privlage? if so, how might I be able to change the password? -- Jerry M. Howell II -- MySQL General

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

2003-09-06 Thread Jerry M. Howell II
I figured it out. Actualy silly me forgot to add the password() function how embarising. :) -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

2003-09-05 Thread Jerry M. Howell II
to the databases. Does anyone have any idea whats going on and how I might be able to resove this problem? Thanks, -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using p assword: YES)

2003-09-05 Thread Jerry M. Howell II
? Anyideas. Might root not have the privlage? if so, how might I be able to change the password? -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql database dump (remotely, How?)

2003-06-28 Thread Jerry M. Howell II
it to my computer but hardheaded me would rather do it simply by dumping it from the remote computer to my home puter via mysqldump :). Thanks for any help. -- Jerry M. Howell II -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysql database dump (remotely, How?)

2003-06-28 Thread Jerry M. Howell II
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote: On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote: lol of course mysqldump -u username -p databasename databasename.sql I am atempting to backup a database remotely. I added something like the following

Re: Mysql And Backup

2003-03-21 Thread Jerry M. Howell II
scripts for backing it all up will of course be welcom as well. second off, how do I wipe these old databases off my puter :) thnx, -- Jerry M. Howell II - Before posting, please check: http://www.mysql.com/manual.php

Re: Mysql And Backup found a solution

2003-03-21 Thread Jerry M. Howell II
,@dblist); } # Exit -- Ah DUH! exit 0; -end code OK, a little long for a perlscript but it works, and much faster than mysql dump -- Jerry M. Howell II - Before posting, please check

Re: encrypted password

2003-02-06 Thread Jerry M. Howell II
| | chichi | jian1830 | +--+--+ I want the passwd field not to be plain text but encrypted. how can i do that? Not for sure on the exact syntax becuse I've always used myPhpAdmin's md5 utility but it would be something like MD5(jian1830) this would do an MD5 hash -- Jerry M

Re: Book recomendations

2003-01-08 Thread Jerry M. Howell II
for the advanced person because I'm not realy advanced but mabe skim through it if the bookstores have it and see what you think or read the reviews on the book on bn.com or mabe others on the list could give feedback on this. -- Jerry M. Howell II

mysql and php

2002-12-02 Thread Jerry M . Howell II
it's nessisary topost it here. Is there any permision issues I should look into or something they might have overlooked in the install? I apreciate any help I can get on this issue. thnx -- Jerry M. Howell II - Before posting

Re: mysql and php

2002-12-02 Thread Jerry M . Howell II
[EMAIL PROTECTED] wrote: this is a vague one , would be good to copy and paste the php debug message = Original Message From Jerry M. Howell II [EMAIL PROTECTED] = Hello all, We are leasing a dedicated server and seem to pe having problems getting our php script working with mysql

Re: mysql and php

2002-12-02 Thread Jerry M . Howell II
compare the database to the script in the first place. gr On Mon, 2 Dec 2002 23:34:45 -0500 Jerry M. Howell II [EMAIL PROTECTED] wrote: Error in input query start of php database code * $connection = mysql_connect(localhost, hostbyk1_admin, mypassword