similar to: Question about dump on MySQL

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