The MySQL & OpenLDAP database on my Debian are very lightly updated.
Usually I tar everything on / including the databases.
The restore works OK on another machine.
I want to know whether its safe to do file level backup of databases like this ?
Do the MySQL & OpenLDAP databases have mechanisms to start even if some records are inconsistent ?
Hello all, new to this forum (member of many others). Hopefully I can find help here.
SERVER:
Brand new server Oracle Enterprise SPARC T4-1
Loaded Solaris SPARC 10 u10, patched to 147440-27
Loaded OpenLDAP v2.4.30
Loaded Berkley DB 4.7.25.NC Loaded OpenSSL 1.0.1c
Note: All packages are... (2 Replies)
"Samba," I know, I know. However, I am a gov't worker and Samba is off the table. Does anyone have a recommendation for an off the shelf, secure solution? I've already suggested rsync and NFS services for Windows Server and got shot down. (4 Replies)
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
I am not a DBA or an unix admin (I am a developer) and I have a
question I need clarification for.
Recently one of our oracle ebusiness suite server (apps tier, red hat 4) crashed and the unix admin had to rebuild the server. We had backups for the file system under applmgr and oracle. And... (3 Replies)
Hi ALL...
I have an IMAP server & I have setup rsync to copy all mailboxes (MailDir) to a remote backup machine.
rsync is working fine and is copying my files.
I need some advice on how to restore a particular mailbox when a user makes a request
assuming she has has deleted an important... (1 Reply)
I need information what maximum error level on FC card need clasification of critical level (SAN mass storidge)
Please write screenshot from utility fcutil whith test option.
Pawel (0 Replies)
how do i install php & mysql with apache on suse linux ???
apache was installed and configured when i installed linux.
all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/
so how do i install php and get it to work with apache and... (4 Replies)
MYLOADER(1) mydumper MYLOADER(1)NAME
myloader - multi-threaded MySQL loader
SYNOPSIS
myloader --directory = /path/to/mydumper/backup [OPTIONS]
DESCRIPTION
myloader is a tool used for multi-threaded restoration of mydumper backups.
OPTIONS
The myloader tool has several available options:
--help Show help text
--host, -h
Hostname of MySQL server to connect to (default localhost)
--user, -u
MySQL username with the correct privileges to execute the restoration
--password, -p
The corresponding password for the MySQL user
--port, -P
The port for the MySQL connection.
Note For localhost TCP connections use 127.0.0.1 for --host.
--socket, -S
The UNIX domain socket file to use for the connection
--threads, -t
The number of threads to use for restoring data, default is 4
--version, -V
Show the program version and exit
--compress-protocol, -C
Use client protocol compression for connections to the MySQL server
--directory, -d
The directory of the mydumper backup to restore
--database, -B
An alternative database to load the dump into
Note For use with single database dumps. When using with multi-database dumps that have duplicate table names in more than one database
it may cause errors. Alternatively this scenario may give unpredictable results with --overwrite-tables.
--queries-per-transaction, -q
Number of INSERT queries to execute per transaction during restore, default is 1000.
--overwrite-tables, -o
Drop any existing tables when restoring schemas
--enable-binlog, -e
Log the data loading in the MySQL binary log if enabled (off by default)
--verbose, -v
The verbosity of messages. 0 = silent, 1 = errors, 2 = warnings, 3 = info. Default is 2.
AUTHOR
Andrew Hutchings
COPYRIGHT
2011, Andrew Hutchings
0.5.1 June 09, 2012 MYLOADER(1)
MySQL & OpenLDAP - file level backup