Server :: Mysqldump Export Type Update / Command Line Or By A Simple PHP Code?
Jan 2, 2011
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 ?
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 am having a 1 gb of mysqldump. When i try to restore this dump file, it is giving error " ERROR 1153 (08S01) at line 289: Got a packet bigger than 'max_allowed_packet' bytes". And with this i am not able to restore the database. mysqld version is 5.0.77.
On Ubuntu Desktop editions, there is a GUI application which allows easily changing to a different server. It can even find out how one is the fastest update server.Is there a corresponding command line tool available to do this? Because I'm using the Server edition without GUI. I hate to manually edit /etc/apt/source.list.
To hide the user input to be displayed on screen, use the terminal line setting command stty -echo, whatever the user enters after this command will not be displayed in the screen. to make the input characters get displayed on the screen use stty echo.
I just want to see how the command line such as : "cat", "split", "ls"...ect source code ? Are they written in C or other language ? I don't know where to search those?
Is there a way to get DVD region code from command line (linux/ubuntu 9.10)? I want to script this action and store the region code (and other data about DVD) in a log.
I am looking for the info about media, not the drive.
I thought this question's best category would be in the newbie sectionBasically I have a C code, (for simplicity is only prints a few lines), called printx.c that I would like to convert into a binary file so whenever I have to type "printx" in the command line it would execute the programofcourse gcc will give me a binary file if I do a "gcc printx.c", but even the output file (e.g. print.outwould have to be executed following manner./print.outI only ask, because I notice programs like mailx (which is written in C) is a binary file that could be run in this manner (at least that's what I notice on my ubuntu distro)
I'm trying to get the source code of a web page from linux command line and save it to a file. I googled for it but didn't get any info. I'm not sure if wget can do this.
So, I usually write/find a test case generator for any code that I write. This type of code generally leads to some file output. To be thorough, I try and generate many different files to test my code on.
Say the command is like this:
Is there a way to automate this for many different values of the parameters and generate many different files?
I tried:
I wasn't able to use the $i in the filename, and without it the command gave me no errors, but did nothing else either. I know the Unix command line is very powerful, and I have a feeling that this should be possible, but I just don't know how to do it.
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.
simple scan error as follows: Failed to save file ImageMagick returned error code 11 Command line: convert -adjoin /tmp/simple-scan-DA9MBV.jpg /tmp/simple-scan-XCK4BV.jpg /tmp/simple-scan-NZVYBV.pdf Stdout: Stderr: using karmic note: I have apparmor extra profiles installed but didn't notice one that related to simple scan or imagemagick. Red herring or not?
I have a few PCs that are used by average joe's and whenever updates are available the update applet apears indicating there are updates. I usually update all these machines at the same time using zypper so in order to remove additional confusion how can I disable this? I've read in the forum how to stop it from starting up by going to Control Center | Startup Applications and unchecking Packagekit Update Applet. Is there a way to do this using the command line? I'm sure there is, after all this is Linux, I just need to know how. Reason being is I'll be ssh'ing into these machines to disable the update applet and don't want to touch all the machines and click my way to stop it at startup. Figure there has to be an easier way
I made a live USB memory stick / pendrive with Ubuntu netbook remix 10.04 using my desktop computer. I want to install / update my netbook that has no network function yet. I booted the desktop with the pendrive & ran update manager. I want to update the kernel so I will have the driver that will operate my netbook ethernet.Acer AOD260 has Ethernet Controller: AR8151 v1.1 Fast Ethernet, Atheros Communications & Network Controller: Broadcom 4727 (rev 01)and will not work from the current release of 10.04 (too new) but there are supposed to be drivers in the newer kernels.
Running Update Manager I get a box labeled "Debconf on ubuntu" & says "Configuring grub-pc". There is an entry box that says "linux command line:" & is empty. When I press the help button I get the message "The following Linux command line was extracted from /etc/default/grub of the 'kopt' parameter in GRUB Legacy's menu.lst. Please verify that is correct, and modify it if necessary.The installer is hanging, Preconfiguring packages ..., probably waiting for a response, but I have no idea what to do.
I recently updated, and now when I boot it only goes as far as grub command line. There is no grub menu. The computer is a Dell Inspiron 8600 laptop with only Ubuntu installed -- no dual boot, no weird partition schemes. Originally installed Ubuntu 09.04 on this computer, upgraded a couple times and it currently has (had) 10.04.1 LTS running. The update should have upgraded from kernel 2.6.32-23 to 2.6.32-24. I can boot with a live CD and mount the hard drive. The drive seems fine, so it appears to be simply a grub config issue. I have to boot with live cd to get online to check for potential solutions. So I'm taking some notes on how to use grub.
I have one doubt, is copying /var/lib/mysql is a good alterntive to mysqldump?.
Because i use rsync to copy /var/lib/mysql for back up without dumping the database. I use rsync to do differential backup up so that it copies /var/lib/mysql to /var/tmp every one minute.
We are running an adserver with mysql as the database. We backup the database every hour and lately noticed that ads doesn't get delivered at the time of backup. The database size is 1.2 GB in which a single table ifself is 1.1 GB. Googling around the problem says this may be due to lock table feature in mysqldump and disabling it might solve the issue but i'm afraid whether this would be a problem. Can anyone please explain what lock table means and will it be a problem if i disable it or may be any other alternative solutions/assitance (other than master/slave or replication since we cannot afford it at this time) would be really helpful.
how do you download an update or an upgrade (or whatever it's called) on a command line. for chromium internet browser. opened the computer and couldn't watch videos. i tried all the downloads available on adobe's website and all of them are on my "downloads" folder and when i click on any i just get stuff i don't understand and i simply find it easier to download through terminal.
I upgraded from Meerkat to Narwhal. After all the files have been downloaded and installed it rebooted. Once it rebooted it went straight to the GRUB command line. After couple of hours of research, I ended up at [URL]
My root was at (hd0,1). So therefore I put this in at the GRUB prompt.
set root=(hd0,1) linux /vmlinuz root=/dev/sda1 ro initrd /initrd.img boot
I did what it said and it got me into Ubuntu. Nice! It asked me to: After successfully booting into the system the user should run sudo update-grub I did. Next it asked me to review (/boot/grub/grub.cfg). That's where it is hairy, my file has multiple root settings and with msdos settings. That doesn't seem normal.
I installed this graphics card update in kubuntu 11.04 [URL].... And when now kubuntu boots to a command line interface login screen I don't mind reinstalling to fix it, i would just like to install the latest version of the graphics card driver. I've tried twice with the same results, how i can fix it?
I compiled the 2.6.31.6 kernel and <insert drumroll> it boots!(my first kernel roll, I'm kind of shocked actually) That's the good news. The bad news is that my NVIDIA drivers are gone in the wind. That's not entirely true as I can still boot into the old kernel and startx. Is there a way to download the driver using the command line for reinstall?
I have a project due for my Intro to C++ class and we are suppose to generate a file listing that will take an input of a C++ source code with .cpp extension and make a copy of it with a .lst extention that will have a line number preceding each and every line.
i've gotten my fedora 12 to the point where i can run python3 scripts from command line and can call up python 2.6.2 idle with the command 'idle' from command line. what command will call up python3 (3.1.2 to be exact) idle?
I have some tables that contain special characters from different languages like German, Italian, Russian, Spanish etc. They are stored and displayed correctly.
When want to backup my DB like "mysqldump -h localhost-u root -p dbname > dbname.sql" the special characters are lost, they are not correctly stored nor displayed in the sql file. This means there is no possible restoration.