appened at least a few times
already. I just add it into a script and copy it to the apropriate
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 Gen
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]
TE user SET Password= ('x')
> -> WHERE user='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
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 Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nd that users can't login 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]
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
it backup on the server and scp 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
#x27; . $db .
' 2>&1>/dev/null');
print "Cleaning up after $db...\n";
system('rm -rf ' . $DATADIR . '/' . $db . ' 2>&1>/dev/null');
}
}
}
#
# Main
# ----------
What I'm looking
for is any other recomendations to backup and restore 71
databases. Any 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
---
thing like
MD5("jian1830")
this would do an MD5 hash
--
Jerry M. Howell II
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
it works 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.
--
J
idn't 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_conne
t from the command line and can access the
database just fine
it might be a scripting error but I've searched the web for
templates and they
all seem to use this format so I'm stumped
On Mon, 2 Dec 2002 23:59:35 -0500
daniel <[EMAIL PROTECTED]> wrote:
> this is a vague one , wou
u all feal
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
-
14 matches
Mail list logo
