Displaying 20 results from an estimated 600 matches similar to: "Question about dump on MySQL"
2014 Nov 10
3
backup incrementals on mysql
Hi all.
I usally make backups of databases mysql.
I make buckups of all datbase for example:
mysqldump -u user -ppassword name_db > backups.sql
also I make backups just its schema for example
mysqldump -u user -ppassword name_db --no-data > backups.sql
but now I need a backups incrementals, because the size of DB is very big
(500 mb)
How to make this?
regards
--
*Atte.
2016 Nov 17
4
Skype for Centos Desktop
Hi all.
I search info in the web about how to install skype on centos 6.5, but just
exists info about skype with architecture to 32 bit.
someone can me explicain, how to install skype for 64 bit architecture ,
it's possible?
thank
--
*Atte. Rodrigo Pichi?ual N.*
*Ingeniero Administrador de Sistemas Linux*
*rodrigo.pichinual at gmail.com <rodrigo.pichinual at gmail.com>*
*+56 9
2014 Oct 02
2
CUPS Enable printer from command line
Hi all:
I am investigating about Common Unix Printing System (CUPS).but, I have one
doubt, when I execute the command "lpc status" , the output it's :
for example:
Printer-one:
printer is on device 'lpd' speed -1
queuing is enabled
printing is disabled
10 entries
daemon present
so the status the printer it's "DISABLED",
I changed in the file
2014 Mar 04
3
Error sending a email to account of email personal (postfix)
Hola a todos:
Tengo la siguiente interrogante:
Resulta que tengo centos 6.4
al ejecutar el siguiente comando:
1) MTA
alternatives --config mta
la salida es la siguiente:
-----------------------------------------------
+ 1 /usr/sbin/sendmail.postfix
* 2 /usr/sbin/sendmail.sendmail
Lo cual indica que esta usando postfix.
pero NO TENGO configurado postfix.
2) ENVIAR
2016 Nov 18
2
Skype for Centos Desktop
On 18/11/16 11:01, Liam O'Toole wrote:
> On 2016-11-17, Rodrigo Pichi?ual Norin
> <rodrigo.pichinual at gmail.com> wrote:
>> Hi all.
>>
>> I search info in the web about how to install skype on centos 6.5, but
>> just exists info about skype with architecture to 32 bit.
>>
>> someone can me explicain, how to install skype for 64 bit architecture
2013 May 29
2
NCFTP eliminar directories no vacios
Hola a todos,
no se si esto es posible, la verdad es que ncftp me parece muy util y
eficaz, pero lo unico que le puedo criticar es que no puedo eliminar
directorios que no estan vacios...
estaba viendo la documentacion y al parecer esto es posible si configuro el
servidor al que accedo desde mi maquina local(CLIENTE)
habra alguna manera?
Gracias
2012 Jul 27
1
No tengo red despues de instalar
Que tal amigos:
Resulta es que no tengo red despyes de instalar centos 6.2,
sigo la ruta: /etc/sysconfig/network-scripts/
y no me aparece el archivo ifcfg-eth0
e visto cosas similares de otros usuarios de centos....
donde si encuentran ifcfg-eth0 y tienen que modificar el Onboot a yes, pero
ami no me aparece?
realice la instalacion minimal.
--
Rodrigo Isaias Pichi?ual Norin
Ingeniero en
2015 Mar 11
1
consuming a high percentage of cpu
the kacpid proccess is consuming a high percentage of cpu.
this makes my server it's slow
how to solve this .......????
--
*Atte. Rodrigo Pichi?ual N.*
*Ingeniero Administrador de Sistemas Linux*
*rodrigo.pichinual at gmail.com <rodrigo.pichinual at gmail.com>*
*+56 9 87272971*
*@Roodrigo0461*
*http://cl.linkedin.com/in/rodrigopichinual
2014 Jan 26
1
Cambiar nombre al host sin reiniciar el sistema
Hola a todos:
Yo quiero cambiar el nombre de mi host, pero sin reiniciar el sistema
1) edite el archivo /etc/sysconfig/network
HOSTNAME=name_hostname
2) edite /etc/hosts
192.168.x.x name_hostname
Se que al reiniciar cambia el nombre, pero mi idea es no reiniciar el
server.
se puede???
gracias
2014 Mar 31
1
Supervise Directory With TRIPWIRE
Hi all
I have a question, I need supervise a directory of apache on centos
The directory it is:
/var/www/html/application/........
But I not know if this it is possible...
Tripwire Can supervise the directory and all files within ?????
this it is possible mofidy the policies for default???
Thank
2010 Aug 14
6
best ways to do mysql backup
we have multiple servers approx 10 and each has about 100 GB of data in
the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we
take backup for these databases on to a remote machine and store them
datewise , ( the remote machine is a 2TB HDD )
currently tar is not feasible as the data is too huge and the same goes
with mysqldump
suggestion will be of great help
--
2014 Aug 13
2
MySQL - replication - how to restore master?
Hello,
We have MySQL running as a master which is replicating to a single slave
server. We are, however, considering what is required when a 'disaster'
of some sort happens to either server. By disaster, this could be some
event which requires the entire server to be rebuilt, and which would
usually include restoring from nightly backups directories such as
'/var/lib/mysql' and
2012 Mar 05
5
cron job not running
hello list,
I am attempting to backup a centos 5.4 (x86_64) server running mysql
with a cron job. Here's how the cron job looks:
[root at cloud:/home/bluethundr/backupdb] #crontab -l
* 3 * * * /usr/bin/mysqldump jfwiki >
/home/bluethundr/backupdb/wiki-$(date +%Y%m%d).sql
However if I run the command from the command line it seems to work fine.
If I grep syslog for cron this is what
2004 Nov 11
1
rsync --rsh not reading .ssh/config
I've setup up a single-use key on a remote host to run rsync in server
mode. I've also setup .ssh/config locally with an IdentityFile to
select the single-use ssh key.
This works on my Debian sid machine:
rsync --rsh="ssh remove_host" ::
But on another machine that command (and others tried below) do not
access .ssh/config. The machine is running these:
$ ssh -v
2007 Dec 04
2
Help to restore mysql data on CentOS 5
Hi ,
Help is needed to restore mysql data
This is the the setup.
2 Servers running on CentOS.
one server has both apache an mysql.
the other server only has mysql database. This server has about 12000
records in the database. Last week, It had about 6000 records. then,
Someone has backed up these 6000 records to the web server. Now , We need
to backup all 12000 records to the webserver.
2009 May 26
6
dump and import MySQL table w/ accents
I am switching to a composite primary key (string and user ID) from the Rails
conventional auto-incrementing integer primary ID. The table is large (2.5
million records) and I''d rather not discard the contents. The
composite_primary_key gem doesn''t appear to support altering the table with a
migration to do its magic, only creating a table from scratch. So I dumped
the table
2006 Apr 29
2
nuby migration question -- data migration, MySQL => postgresql
How do I best migrate the data? For small databases I can text-edit the dump file from
MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can
MySQL export CSV that postgresql can import ?
W Fred
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2012 Oct 01
5
s3 as mysql directory
Hello list,
I am soliciting opinion here as opposed technical help with an idea I
have. I've setup a bacula backup system on an AWS volume. Bacula stores a
LOT of information in it's mysql database (in my setup, you can also use
postgres or sqlite if you chose). Since I've started doing this I notice
that the mysql data directory has swelled to over 700GB! That's quite a lot
and
2008 Oct 01
1
Rsync efficiency on SQL dump files
G'day,
I'm backing up production MySQL database servers. The tables are almost
all MyISAM.
My plan is to use MySQL binary logging and then rsync the binary logs
offsite hourly. The binary log files are only appended to, with new
queries logged at the end of the file. So I'm assuming the rsync
algorithm will be highly effective at reducing the bandwith required to
transfer these
2008 May 26
1
Can't seem to export MySQLDump and then import MySQLImport?
I''ve got my applications running on a server that backs up every hour
using MySQLdump.
My goal is to take this ''dump'' and re-import it into my desktop
computer using MySQLAdministrator.
I go through the procedure of restoring this ''backup.sql'' file and it
grinds for some time as though something is happening...and then
nothing??
There are no error