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
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
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]
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]
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
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]
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
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
-
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
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
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
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
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
---
#x27; . $db .
' 2>&1>/dev/null');
print "Cleaning up after $db...\n";
system('rm -rf ' . $DATADIR . '/' . $db . ' 2>&1>/dev/null');
}
}
}
#
# Main
# ----------
14 matches
Mail list logo
