Red Hat / Fedora :: Pipe MySQL Dump To FTP Without Writing To Disk
Aug 8, 2010
I've got a Centos 5 machine running with a raid 1 SSD hard drive combo, as I don't know how or even if it's possible yet to wipe the free disk space clean I need to be careful to not fill all the free disk space. As I don't want to fill the free disk space too quickly and was wandering if it is possible to pipe the result of a mysqldump to a FTP client only writing it to the ram and not writing it to this disk.
I've done a bit of research on the subject and have found the two following commands:
Code: mysqldump < mysqldump options> | gzip > outputfile.sql.gz
Code: tar cf - / | ncftpput -c sonic.sega.co.jp /usr/local/backup.tar
I would like to combine the two to make something like this:
Code: mysqldump mysqldump_options > | ncftpput ncftpput_options -c SERVER_IP backup.sql
I haven't actually tried my code as it seems too easy and I'm sure I've got something wrong! If this command is even correct will it prevent the sql file from being written to the hard drive to my local machine?
View 4 Replies
ADVERTISEMENT
Mar 22, 2010
It frozen up occasionally, when that happens, usually the harddisk light lights up continuously. So I suspect some process is writing to the disk, which prevent other process to go on. how do I find out who's using a lot of IO?
View 3 Replies
View Related
Mar 17, 2010
I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql: ambiguous redirect
The working original script:
Code:
#!/bin/bash[code].....
View 1 Replies
View Related
Dec 11, 2010
Does anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?
View 6 Replies
View Related
Mar 20, 2011
I have a problem with a script i wrote, the script runs fine if manually executed however it doesn't run *fully* when executed via cron
here's the script :
Code:
#!/bin/bash
FILENAME=mysql_full_dump_`date '+%m.%d.%y'`.sql
`which mysqldump` --all-databases -uroot -p************ -h127.0.0.1 > /root/$FILENAME
RETVAL=$?
[code]....
the script resides in /root/bin and the cron entry is as follows:
Code:
0 0 * * * root "/root/bin/mysql_daily.sh"
the result is the .sql file, but it doesn't archive it.
View 2 Replies
View Related
Apr 14, 2010
I'm quite new to linux, but I've managed to grasp some basics. Now my intention here to create a virtual directory, which I resorted to creating an Image File so that I can mount it and have my folder have a dedicated storage. I will mount this image as a loop device. Well it's not much of a problem, but I would like to know whether this is suitable. Say I want to create a 25GB Image.
Code:
dd if=/dev/zero of=/home/disk-img/25GB.ext3 bs=1G count=25
Is this recommended? I'm using block size as 1G which is really huge, so I was wondering, if this is actually recommended. From what I read, some said that it's only advisable to use 4096k or lower, but what I found was that these suggestions are very dated (year 2003), and it is now 2010, so I would like to know if it makes any big differences.
View 13 Replies
View Related
Nov 15, 2010
No, the disk is not full and there are only a few files in tmp directory, but some MySQL queries return this error:
Error writing file '/tmp/MYrZo6Qh' (Errcode: 28)
Something strange:
PHP Code:
select from table where c1='1' and c2='1' and c3='1'
returns Error 28 but
PHP Code:select from table where c1='1' and c2='1' and c3='0'
View 6 Replies
View Related
Mar 2, 2011
I've written a simple server in linux used fork to create a FIFO pipe.The server create two FIFO pipe.One for server read data from client and write data to client.Then another pipe for client read data from server and write data to server.When the server read data from a client used server-pipe and then write data to client.But ,if the client no read open the pipe,the server side write will be crashed because of a broken-pipe SIGPIPE. How to check whether the read side is opened?Or,how to catch the SIGPIPE,and then my server will still execute on,not crashed!!
View 5 Replies
View Related
Aug 7, 2011
I've just completed a fresh install on natty, and I'm seeing constant disk writes of around 1Mb every couple of seconds.
I looked at iotop to find the culprit, and it seems to be the journalling manager for the ext4 filesystems:
Code:
215 be/3 root 0.00 B/s 19.23 K/s 0.00 % 5.89 % [jbd2/sda1-8]
Is there something I can do to adjust this behaviour somehow? I'm a bit concerned about wearing the disk out before its time...
View 2 Replies
View Related
Nov 18, 2010
I'm writing a script that among other things partitions and formats disks using SW RAID and LVM. I've read somewhere that for older versions of Linux it was a good idea to use the dd command to zero the first couple of blocks od a device before partitioning it (or formatting it?) Is this practice still recommended? To what end?
View 1 Replies
View Related
Sep 6, 2010
I have used Dump Command to dump the application files. For Full backup the level 0 is working fine. For incremental backup I used the level 1 or 2 it is getting the error as
DUMP: Only level 0 dumps are allowed on a subdirectory
DUMP: The ENTIRE dump is aborted.
The code I used
===============================
#!/bin/bash
#Full Day Backup Script
#application folders backup
#test is the username
now=$(date +"%d-%m-%Y")
[Code]...
View 2 Replies
View Related
Apr 10, 2009
I'm doing ping between 2 RH servers through a VPN site2site tunnel and in some times I got in the result pipe 2 and another pipe 3 as I mark it in blue color below.
e.g.
64 bytes from 192.168.1.10: icmp_seq=0 ttl=128 time=0.229 ms
64 bytes from 192.168.1.10: icmp_seq=1 ttl=128 time=0.287 ms
64 bytes from 192.168.1.10: icmp_seq=2 ttl=128 time=0.278 ms
[code]....
What's the difference between pipe 2 and pipe 3 and what's the meaning of it?
View 1 Replies
View Related
Jan 18, 2010
This is a curiosity of mine, and I expect a technical answer, if someone knows it. Why the systems become so irresponsive when doing hard-disk input and output? This happens even if writing is done to a secondary disk where neither the system or the swap are stored.
View 7 Replies
View Related
Oct 27, 2010
I've got a few linux boxes (fedora 13 and 11) with a common disk mounted. I'm trying to get them all to write files to that disk, however it seems that only the first to connect actually has permission to write.
I'm very new to this networking stuff and this is a bit of a hack. Is there anyway to give all computers write access to a disk (it's actually a managed back up disk, primarily for windows users but is the only shared disk in the building), or is this likely to be very very complicated?
View 8 Replies
View Related
Oct 7, 2009
I want to generate core dump files from my program when it crashes. Its a pretty big process and has about 10-11 threads in it.I have followed the documentation to enable core dump by setting ulimit to unlimited etc. I quickly tried "A demo program creating a core dump" from the following webpage, which succeeds in Segfault and dumping a core file in the directory that I configured.However, I tried running my original program and caused it to crash. I did this by making calls to kill(), raise() or the same null pointer access as shown in the webpage above. In each case, my program crashed but did not generate a core dump file. Am I missing something?My program is in C++ and my environment is Redhat 9.0 (kernel 2.4.20)
Going through the "Why do I NOT get a core dump?" section on the same webpage as above, I can see two potential problems. One - there are issues with the suid/sgid (bullet # 6). I am not able to change any settings with suid because my system does not contain either /proc/sys/fs/suid_dumpable or /proc/sys/kernel/suid_dumpableTwo, my program has threads in it and the bullet # 8 is the problem.
View 1 Replies
View Related
Dec 9, 2010
i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"
View 1 Replies
View Related
Jun 27, 2011
K3b provides a comfortable user interface to perform most CD/DVD burning tasks. While the experienced user can take influence in all steps of the burning process the beginner may find comfort in the automatic settings and the reasonable K3b defaults which allow a quick start. If you want to install K3b goto ubuntu software center and type K3b in such box and press install button After installation is over open K3b when you open for first time you will see a box called "Did you know...? read that and press Next button. After reading all close that box and use K3b for CD/DVD burning tasks. You want to Add-ons for K3b select six add-ons and press Apply Changes button that all you can use it now. If you want to install K3b through Terminal window follow the this commands To install K3b
sudo apt-get update sudo apt-get install k3b Preview audio tracks withing the playlist editor is one of the features in K3b, you need to install and start arts sound server for this sudo apt-get install arts artsd & you may need to install mp3 plugin for built-in decoding software. sudo apt-get install libk3b2-mp3 Enjoy now.
View 3 Replies
View Related
Sep 27, 2010
Whenever I am busy reading or writing large files, or large sum of files, my computer is unresponsive. Screens are getting greyed-out and I just can sit there and wait until the reading/writing is done.
This is not caused by the CPU which is overstressed because it is not. Look at the attachments and you will see the CPU is used for about 20%. When these pictures were captured the computer was using hellanzb to unrar a long list of rar-files.
When you look at my signature you see the computer is not bad at all, just disk-access is slow. I can transfer files with a maximum speed of 30MB/s. Is that normal or is it very slow? I don't know the numbers. I have 2 SATA disks.
O.S. is Mint 9-Isadora, based on Ubuntu 10.04 and I use the 64-bits version.
View 9 Replies
View Related
May 27, 2011
For internal security reasons I need to prevent ourmcat logs from writing to the webserver local disk. We set up a separate logging server with rsyslog and need to pipe the log data to it.I am trying to work out how to configure tomcat to send all log data to the logging server via the rsyslog client (running locally) via a named pipe. We are on CentOS 5.6, Tomcat 6 and rsyslog 5.8.1. I need to know: 1) do we use the default logging library or log4j2) where is this configured in the tomcat config3) is there any code that would need to be written to achieve this
View 1 Replies
View Related
Jul 17, 2009
i've got a non-typical problem here. i've got kvm-ed freebsd (its not so important here) stored on a block device - /dev/sdb8. i wanted to install fedora rawhide there but first i thought it's a good idea to do some backup. so here we go dd if=/dev/sdb8 of=freebsd.img bs=4k
theoretically, dd should do the thing without saying a word, but it doesn't. every time it stops after reaching 16GB filesize (partition is about 35GB) and completely locks the system (only reset helps).the dump worked only once, but when i tried to compress this big image 7z got stucked too and the system froze . the problem occurs when copying to the same drive or to different drive. i've got a partial kerneloops logs, but so far i haven't found the answer.
Code:
Kernel failure message 1:
BUG: Bad page state in process bash pfn:14a224
page:ffffe200048377e0 flags:0040000000000000 count:0 mapcount:0 mapping:0000000000000002 index:2a4b (Tainted: P )
Pid: 9711, comm: bash Tainted: P 2.6.29.5-191.fc11.x86_64 #1
Call Trace:
[<ffffffff810a2be0>] bad_page+0x11d/0x130
[Code]....
View 2 Replies
View Related
Dec 15, 2008
I'm having trouble trying to get a thread dump for tomcat. I have tried the following and none seems to work:
kill -3 <pid>
kill -QUIT <pid>
killall -3 java
Nothing shows up on screen. I also tried putting the out of the dump to a file with the > command but the file is blank.
View 5 Replies
View Related
Jul 22, 2011
Does somebody knows which key is the pipe sybool in virtualbox?
View 3 Replies
View Related
Aug 19, 2009
I have a bug where WoW under wine is crashing my computer, and I want to get the data from the console, so I want to put it in a file, but I don't know how! None of the piping tutorials online helped at all.
View 2 Replies
View Related
Feb 19, 2010
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies
View Related
Feb 22, 2011
I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
View 7 Replies
View Related
Apr 2, 2009
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies
View Related
Jan 16, 2011
I have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
View 6 Replies
View Related
Feb 11, 2010
I'm new to linux, been using fedora 12 for about a week. I just noticed a problem with my keyboard layout. When i press the key with the backslash and pipe character, i get < for backslash and > for the pipe character. I have tried the following to fix the problem:
1.$ gnome-keyboard-properties then selected the proper keyboard model (Asus Laptop) tried adding different keyboard layouts and setting them as default nothing i did there made any difference.I am currently using USA, i have tried Canada English, USA international, and more I noticed that even when i change it to something like Afganistan, there is no noticable different when i type in the test area. I notice that there are keyboard layouts that have < and > where the backslash and pipe character should be, but the picture for USA shows the pipe and backslash where they should be.
[Code]...
View 3 Replies
View Related
Nov 16, 2010
we had a CENTOS 5.5 x86_64 machine with 8ered with MySQL 5.0.91-community.Currently we had a very high number of Created_tmp_disk_tables (31k in 4,5 hours!!!).I've read suggestion that we need to increase tmp_table_size, and we've set tmp_table_size to 64M, but this drupal modul's query still cause mysql create tmp table on disk
Code:
SELECT DISTINCT node.nid AS nid,
comments.subject AS comments_subject,
[code]...
View 4 Replies
View Related
Apr 10, 2009
my net worked HP printer will not print-broken pipe - this started after I had to switch off the printer at the mains in order to attend to a paper jam. Now it will not print apart from a test page. I am using Fedora 10 and the device info is "hp:/net/Officejet_Pro_L7500?ip=192.168.0.4"
View 5 Replies
View Related
