General :: Copy Db And Type Some Mysqldump Command?
Jul 20, 2010
i use linux ubuntu..i try to copy db and type some mysqldump command..but at terminal show: The program 'mysqldump' can be found in the following packages:
* mysql-client-5.0
* mysql-client-5.1
Try: sudo apt-get install <selected package> bash: mysqldump: command not found
how to get mysqldump for my pc? i've tried to follow the instruction,but show like below:
Err http://ubuntu-ashisuto.ubuntulinux.jp jaunty/main libnet-daemon-perl 0.43-1 Could not connect to ubuntu-ashisuto.ubuntulinux.jp:80 (122.216.218.146), connection timed out
I noticed in phpmyadmin that we can export a database in type update. Indeed we have update... in place of insert.... is there anyone know if it possible by a command line or by a simple PHP code ?
When I execute the command below, does mysqldump lock all tables while the backup is in process? I want to make sure this is the appropriate type of backup command for MyISAM database.
How to copy a Read-Only file in Linux and make the copy writable with a single cp command in Linux (Ubuntu 10.04)? The --no-preserve and --preserve seemed to be good candidates, except that they should "and" the mode flags, while what I am looking for is something that will "or" them (add +w mode).
More details: I have to import a repository from GIT to Perforce. I want that all Perforce depot files are Read-Only (that is how Perforce was designed), while all other files that were derived/copied from depot files are writable. Currently if a Makefile tries to copy a Read-Only file then the derived file will also be Read-only. This leads to build-errors when cp tries to overwrite Read-Only file second time. Of course the --force is a workaround here but then the derived file is also Read-Only. Also I do not want to mess with "chmod" after each "cp" command - I will do that only as the last resort.
I accidentally type mv command wrong.actually it supposed to be mv SNAP-20101215* dec10/week3_dec10/but i type the below insteadmv SNAP-20101215* dec10/week3_dec2010/Note: there is a folder name "dec10/week3_dec10/"but there is no folder name "dec10/week3_dec2010/"as a result of it, instead of having those files under dec10/week3_dec10 but it merge those files into one file name "week3_dec2010" , is there any way to change it back to orginal files?
I have a LAMP website with mysql backend with InnoDb engine for tables.I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. shutting down the website) for the duration of the backup. not even in the mySQL documentation. A lot of mention is made about mysqlhotcopy, but that only works for IMSAM tables - and is therefore of no interest/use to me.Does anyone know if (how?) I can use mysqldump to take a copy/dump of a database that is still being used?.A link to the official documentation would be very useful, since I want to make sure that I get this absolutely right.I am running on Ubuntu 10.0.4 LTS
I need to extract the absolute directory from the type command when I pass it a program name. E.g.
Code:
>type cat cat is hashed (/bin/cat)
There is one other case (I believe):
Code:
>type lpr lpr is /usr/bin/lpr
I thought of using regex, but it returns the whole line, not just the match. In addition, there is no option cited in the man page for type that returns just the command directory.
Note: this is part of my solution to a programming assignment in bash shell scripting.
Is it possible to compress the mysqldump output into say db_backup.sql.tgz. Then add that to an existing archive e.g. backup.tgz in one command or on the fly to save space and deleting it?
I came across this reult of the type command (hashed) in another post. (see below).
Code:
fraespappp8:/data/apps > type topic_file_publish.sh topic_file_publish.sh is hashed (/data/apps/pnbgstk/publication/topic_file_publish.sh) This (result = hashed) is new to me.
I've this script which takes backup of mysqldb through mysqldump. I need to send an automated email after success/failure mysqldump. How can add this feature in the script? Here's the script:
My cron job is executing the below mysqldump command but it produces an empty sql file. However, when I run from the command line, it works as expected.
For example, if I type ':pwd' to get the current working directory, I can select the text in gvim but I can't figure out how to copy it to the clipboard. If I try the same in console vim, I can't even select it with the mouse. I would like this to work with all vim commands, such as set guifont to copy the guifont=Consolas:h10:cANSI output.
I have to transport a lot of files from one pc to another (both Linux). I would like to use scp for that, but scp only allows for transferring one file at a time. How can I do this?
I have No possibility to use rsync or any other protocol No possibility to use passphrase free certificates (but have a certificate with a passphrase) A list of files to transfer and a list with the destination path of the files on the other server The files are spread out over a lot of directories, and not all the files in the directories I want to copy If possible I would like to gzip and ungzip transparently to save bandwidth!
I would like copy a backup file from image vmware linux to windows but i don't know how to process it ?i tried :scp /source/backup.tar.gz admin@x.x.x.x:/c:ProgrammefilesC:Documentsand SettingsAdminMyDocumentsbut error and i know that it's not like that, so if you have solutions
Imaging-copying a working remote share on WindowsNT to a local Linux disk target is needed . Is that possible with dd command(how if remote share is connected as smb://ipnumber/share) and do you need root privilleges on local and remote machine for that?Perhapson source machine:dd if=/dev/hda bs=16065b | netcat targethost-IP 1234on target machine:netcat -l -p 1234of=/dev/hdc bs=16065borrsh 192.168.xx.yy "dd if=/dev/sda ibs=4096 onv=notrunc,noerror" | dd of=/dev/sda obs=4096(any difference to dd/privilleges if you use it as windows dd version since remote is running windowsNT)?
I want to find files of a particular tyepe and particular date to be copied into a seperate folder.How do i do achieve this in a single line using the find and copy command.
Tried this, but there's no such a command in Arch.And this also doesn't work:Code:find ~ | grep -i pidgin | xclipboard Error: another clipboard is already running
I back up all my digital photos to a couple of places. I've been using the cp command, but--given the personal value--have started to wonder if there's a more reliable way. I'm no stranger to Linux, Bash, Perl, etc., so I could write something to copy and compare md5 hashes, but I was wondering if something already exists (reinvention, wheels and what-not).
Most of my googling for copy and (verify|valid|check|hash|confirm) turns up rsync. However, as far as I can tell, rsync only uses hashes to see if a file needs to be updated. It doesn't perform a hash comparison afterward. For this use, specifically, the files are binary and typically 8-10MB.
Any please help me for incremental copy command similar to windows.commad for copying in windows is c: source xcopy *.* destination /s/c/d/q/yany similar command is there in linux as I m new in Linux
I am trying to upgrade PHP on our linux box ( CentOS ) I copied the configure command from the phpinfo and now I want to execute that.I am not able to copy the command from an editor in linux to the command prompt, clicking the wheel om my mouse does not work, neither does shift-insert or ctrl-shift-insert.It does work in the editor itself.Is there a way to do this ?Or is there a way to execute the command in linux while it is in the file ? Like a bat file on Windows ?
I erase XP and do a clean install of 10.04 netbook remix on my Acer AspireOne. Almost everything seems to be working ok (so far.....3hrs after installation and still testing!) except for:
1: My main partition is formatted as ext4, and when I try copy back any (video .iso !) file that is larger than 4.1 gb I get a memory error and so only copies the file incomplete up to 4.1 gb. I know this problem under windows FAT vs NTSF but I have read that ext4 was beyond this... So what did I do wrong? Is the solution to switch the ext4 to ext3 and can this be done without loss of installed programs or files.
2: Video and Sound with video is not good. Lots of disturbance/turbulence and for sure not optimal for both video and sound.
3: my internal micophone is not working in Skype but it does with Sound-Recorder...I connected external mic and this works, but with lots of disturbance. Also the voice sound from telephone calls sound is not as should be.
The "hardware drivers" utility tells me that all is good and no proprietary drivers are in use on the system.
First I hope to undrestand my English word because Iam Arabic girl and not so good in English...
my problem is:
I wrote code in .c file and I run that code on the prompt command, its ture but I want after the out put copy the code on the command by some statment in the code , how can I do that?
I am troubleshooting file copy time issues between 3 servers. I need to copy the same file from server A to both server B and server C and compare the elapsed times for the copy. Is there an easy way to do this?
I'd like to copy a file, say widgets/water.txt, to all subfolders in the folder widgets using a single command. So if the folder widgets has 10 subfolders like widgets/blue, widgets/green, etc. I'd like to copy water.txt to all of them with one command.
I tried the commands
Code:
cp water.txt ./*/water.txt cp water.txt ./*/
However these don't seem to work. The latter gives 'cp: omitting directory' errors.
