By "even as root", do you mean that you did something like this:
$ mysqldump -u root -p db_name > db_name.sql
? The "root" user *in* MySQL should have privileges to run
mysqldump. Describe the situation in a little more detail if
you're still having problems - like:
* what is the exact mysq
erver?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
y* database in MySQL?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Sinisa Milivojevic [[EMAIL PROTECTED]] wrote:
> Hardy Merrill writes:
> > In the 3.23 news article, at the bottom it says this:
> >
> >
> >
> >
the "mysql" client when I
query the row containing the encrypted field, mysql displays
a bunch of strange characters - I can refer to the row by the
non-encrypted key although the same key does *NOT* display
properly in mysql(the encrypted column must be screwing up
the displayi).
Anyone ha
Charles, you need to be more descriptive about exactly what
problem you're having. Spell out your hardware, OS, MySQL
version, etc., and describe what isn't working.
Charles L. Hagen [[EMAIL PROTECTED]] wrote:
> I cannot seem to get this database program to work correctly. I am asking for any
BE AWARE that it is advisable to create a UNIX *NON* "root"
lesser-privileged user for MySQL administration purposes
(running "mysqladmin" for instance) - then scheduled jobs
for MySQL can be run from that non-root user - you could
put an option file
home directory in the
.my.cnf file, as I outlined below.
Mark Maggelet [[EMAIL PROTECTED]] wrote:
> I think it would be easier to just go:
> mysqladmin -uuser -ppassword
>
>
> On Fri, 16 Mar 2001 11:09:37 -0500, Hardy Merrill
> ([EMAIL PROTECTED]) wrote:
> >Charles,
>
atabases/tables.
Nightly, I'd like to
1. run myisamchk to check all databases (not sure if
this is necessary every night)
2. backup --all-databases using mysqldump
3. do flush-logs(probably with mysqldump) so that a new
u
Are incremental backups possible in MySQL? I haven't seen any
reference to "incremental" in the mysqldump or anywhere else for
that matter.
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncr
employee works for, you can use the company_id stored
in the Employee table to find the Company.
Pretty simple example, but hopefully it helps.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Chris Toth [[EMAIL PROTECTED]] wrote:
>
>
> I'm
I'm running mysql with --log-update=update_log with no
extension, so every time I flush the logs I get the next
sequential number appended as an extension to the new
update_log file. If I flush the logs regularly every
day, that sequence number will continue to grow - is
there any way to reset t
field as
the primary key to a table. Keeping the numeric keys used for
basic retrieval separate from the user viewable/updatable fields
makes for a smaller, less-complex, and more flexible program.
Again, just my opinion.
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missi
e log confusion at
flush-logs time? Can locking be enabled on a Linux system?
How? Will this solve my update log confusion with flush-logs?
Is there a way to to manually locking in the script that
does the mysqldump?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
Can/should MySQL be started *without* --skip-locking on Redhat
6.1 Linux?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
-
Before posting, please check:
http://www.mysql.com
e
this update log confusion?
I did notice that when I inserted a sleep 1(or 2) between
the mysqladmin flush-logs and the "mv" that I haven't been
able to "make" the update-logs get confused, but I'm not
very confident that this is "the" right soluti
to finally(after posting this 3
times, and reading all the related documentation I could
find) get a response.
Thank you very much!
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
>
> Now that I know what you are trying to achieve, I can honestly say I'm
cd /dir/to/mysql.server
./mysql.server start
There's quite a bit more to consider, like what user you want
to start the server as, but try that first and see if that will
start the server for you.
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Matt Dav
17 matches
Mail list logo
