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 ?
View 1 Replies
ADVERTISEMENT
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
View 3 Replies
View Related
Jun 2, 2010
Dear Experts,
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.
View 4 Replies
View Related
Sep 12, 2010
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.
View 4 Replies
View Related
Jul 2, 2010
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.
View 1 Replies
View Related
Jan 23, 2009
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?
View 6 Replies
View Related
May 3, 2010
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.
View 1 Replies
View Related
Sep 1, 2010
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)
View 3 Replies
View Related
May 6, 2010
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.
View 4 Replies
View Related
Jun 10, 2011
How to open a file using command line in terminal and edit the code within it ?code...
View 6 Replies
View Related
Dec 4, 2010
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.
View 3 Replies
View Related
Sep 20, 2010
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.
mysqldump -h myhostname --default-character-set=utf8 -u root --password=mypassword --opt --single-transaction DBname > /root/backup.sql
View 2 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
May 1, 2010
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?
View 6 Replies
View Related
Jun 22, 2011
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
View 9 Replies
View Related
Aug 27, 2010
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.
View 4 Replies
View Related
Sep 29, 2010
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.
View 4 Replies
View Related
Dec 2, 2010
What is the command line to update grub in mandriva 2010
View 5 Replies
View Related
Jan 20, 2011
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.
View 14 Replies
View Related
Dec 7, 2010
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.
View 1 Replies
View Related
Mar 12, 2011
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.
View 9 Replies
View Related
Apr 29, 2011
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.
[Code]....
View 3 Replies
View Related
Apr 30, 2011
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?
View 1 Replies
View Related
Nov 19, 2009
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?
View 4 Replies
View Related
Apr 11, 2010
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.
View 12 Replies
View Related
May 25, 2010
I just upgraded servers, and I'm now on 'perl v5.8.8 built for i386-linux-thread-multi' and a simple log script doesn't work. I got it changed to
Code:
#!/usr/bin/perl
use strict;
[code]....
View 4 Replies
View Related
May 29, 2010
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?
View 5 Replies
View Related
Apr 30, 2010
I have created a simple download schedular with source-code give below :
---------------------record_strokes.sh-------------------
touch /home/student/packs/lynx/logfile
lynx -cmd_log /home/student/packs/lynx/logfile
[code]....
View 10 Replies
View Related
Feb 18, 2011
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.
View 3 Replies
View Related
Apr 30, 2010
I have created a simple download schedular with source-code give below :
---------------------record_strokes.sh-------------------
touch /home/student/packs/lynx/logfile
lynx -cmd_log /home/student/packs/lynx/logfile
[code]....
View 1 Replies
View Related