You piece of advice will be very useful for me! How to execute "ALTER TABLE" for a lot of tables in database? I'm going to change engine from MyISAM to NDBCLUSTER. There are several hundreds of tables in database.Command like ALTER TABLE * ENGINE=NDBCLUSTER
View 1 Replies
Does anyone know how to write this command for mysql version 4? (The command is for mysql version 5, I guess since when I check database in mysql server version4 there is no database name information_schema ) command:select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc; meaning:show all database,table name and row count from all databases that has table row more than 1000000
Run result with mysql version 5: mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;
[Code]....
When I shut down I sometimes get some weird errors on screen, and it stops shutting down until I hard reset (hold power down). The errors are something like
Code:
drm:atom op_jump atomBios stuck
drm:atom execute table locked atombios stuck
Also I have my pc set to schedule shutdown (gnome schedule, with "sudo shutdown -h now")My windows side has always shutdown fine, So I don't know if its an incombatilibty with my pc/mobo and the linux kernel ? (half the time it shuts down fine)(?might be due to spin down hard drive option?, or standby settings?)(hibernate on windows has never worked for me)
We purchased a virtual server from GoDaddy (1 month trial) to set up as a proxy for our networks (24 of them). I am having 2 separate issues. The first is I can't configure/install NAT and support is telling me the only way I can is to purchase a dedicated server. Here's the error:
iptables -t nat -A PREROUTING -p tcp --dport 80 -j REDIRECT --to-port 3128 iptables v1.3.5: can't initialize iptables table `nat': Table does not exist (do you need to insmod?) Perhaps iptables or your kernel needs to be upgraded. Here's the fix: [URL] So, what I am hoping to do is configure this by just opening port 3128 directly, and only allowing access from our networks. As a test I did this and allowed only from our office and it did not work. However I can't connect, so I am wondering what I am doing wrong? Here's my squid configuration:
[Code]....
i created a /tmp partition amd mounted it like this:" mount -o loop,noexec,nosuid,rw /usr/tmpDSK /tmp"
I know i can't execute things in /tmp now but is there a way to execute only one file and no more???
IP Tables Comment Module Causes COMMIT Fail
/etc/sysconfig/iptables:
*filter
:CHAIN_X - [0:0]
[code]....
I am facing problem on executing commands like df -h,ls-l,grep etc in /bin.
it is showing below errors:--
----------------------------------------------------------------------------------
login as: root
root@220.226.102.217's password:
Last login: Sat Jun 4 11:14:20 2011 from 220.227.54.149
-bash: /bin/egrep: cannot execute binary file
[code]....
On my old centos 5.2 installation, yesterday my system stopped. The only daemon working was the ping. Every other were not working ( http, svnserver, vncserver, ssh ... ) but yesterday morning everything worked fine! Since the system is headless, I rebooted the computer this morning. Then it never came back. I placed a screen on the computer and when the computer boots, I can see : loading grub stage 2 then I have a black screen with grub>
There is something wrong ... I'm sad because I moved in my new house and did not took the time to restart my backups ( in fact, I did not found the AC adapter for the external drive ) ... I downloaded the brand new centos 5.5 installation DVD and when I try to upgrade my system the installer tells me that the partition on 1 hd is not readable. Then I ignore the message but before getting to the partition manager, it tells me that the partition table for the lvm 00 ( /home ) can not be found and I have to reboot. Since this hard disk is the biggest ( 1tb ) and all of my data is on this one, I'd like to know what I can do to recover this data ?
# iptables -t tproxy -n -L iptables v1.3.5: can't initialize iptables table `tproxy': Table does not exist (do you need to insmod?) Perhaps iptables or your kernel needs to be upgraded. Does exist a tproxy module for CentOS's kernel (2.6.18) ?
View 1 Replies View Relatedi did make a raid server out of some old hardware and 2 new sata disks.setup is: 15 Gb ide harddisk as hda,a pci serial ata controller, with two equal sata harddisk on it (320 Gb each)did a minimal install of centos 5.3 on this (with a yum update after install).i choose for a raid1 configuration of the serial disks.on the command line fdisk -l gives:hda1 hda2, hda3 (swap), hda4 (extended) and hda5 (logical, data partition).added to thatdev/sda1 linux raid autodetect (the first sata disk)dev/sdb1 linux raid autodetect (the second sata disk).both sata disks only have one folder /raiddiskthe last line of the fdisk -l output gives:/dev/md0the size is as each of the sata's is (320 Gb), the listed heads etc. are not equal to those of sda1 and sdb1 (which are fully equal to each other).
as the utmost 'last line' of the fdisk -l output there is a line stating:"disk /dev/md0 does not contain a valid partition table"when i output the fdisk -l command to a text file (fdisk -l > whattheheck.txt) that last line is not in the text file, so centos seems to print it additionally to what fdisk -l brings up.my concern: what does that last line about md0 mean, and how risky is it to ignore it?(writing to the sata disks seems to be okay, both seem to have the same data on them)
I have an external USB drive, with GPT partition label. The drive is cut up into two ~1.5TB partitions When I plug this into my CentOS 5.5 box, the drive is not detected. Instead, dmesg gives me this:
usb-storage: device found at 7
usb-storage: waiting for device to settle before scanning
Vendor: Seagate Model: FA GoFlex Desk Rev: 0155
Type: Direct-Access ANSI SCSI revision: 04
SCSI device sdh: 732566645 4096-byte hdwr sectors (3000593 MB)
sdh: Write Protect is off
[Code]...
i need to prepare a presentation for that i have to copy a table from [URL] to my power point slide. but when i am copying it i am just getting a table with single column. is there a method to import the contents from web page table to my presentation table?
View 2 Replies View RelatedNew Centos 5.4 64bit install on vmware esx 4, NAT net setup. I can ping/trace other servers on IP, do nslookup's on name..Ping(traceroute on name gets me "distination unreachable", indicating an ICMP issue, so I checked the network setup, all looks like usual.Well, except that my routing table lacks the 127.0.0.0 and 0.0.0.0 def. gw entries, as in this working box example:
192.168.9.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
127.0.0.0 0.0.0.0 255.0.0.0 U 0 0 0 lo
0.0.0.0 192.168.9.1 0.0.0.0 UG 0 0 0 eth0
FWIW, during install, I did the usual basic firewall steps,including SSH.Tried with/without iptables, no change; no wonder given the lacky routing table. Sure, I can add what's missing to the routing table, but I'd like to know why it's missing; i.e. what I missed on basic setup, as I'm going to repeat this with a nof new installations (replacing SLES).
I just installed a MySQL server but for unknown reason im not able to set a root password.
CentOS 5.4 - 2.6.18-164.9.1.el5PAE
MySQL Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1
# yum install -y mysql mysql-server php-mysql
# service mysqld start
# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
when I try to send emails to new created emails account, I get this error:
<teste@topdapop.com>: Recipient address rejected: User unknown in virtual mailbox table�
And if I try to send a e-mail, the authentication fails if I setup the account at the desktop email client to password requirement on.
But it works when I try it using a webmail client (Horde) and I receive the email.The old emails accounts work fine. The new accounts and old ones were created with Plesk.I find an entry with
/usr/local/psa/admin/sbin/mail_auth_view | grep teste@topdapop.com
I get no output from
strings /var/spool/postfix/plesk/virtual.db | grep teste@topdapop.com
Using mchk and mailmng does not seems to change that.
I also found the file /etc/postfix/virtual.db .strings /etc/postfix/virtual.db : no output
Kmail 1.13.2 Problem on startup, error is from nepomuk, data storage. "cannot find Redland backend, nepomuk is disabled until fixed. Also see the following error from the akonadi console:
100503 10:00:15 [Note] Plugin 'ndbcluster' is disabled.
100503 10:00:15 InnoDB: Started; log sequence number 0 31413862
100503 10:00:15 [Warning] Can't open and lock time zone table: Table
'mysql.time_zone_leap_second' doesn't exist trying to live without
[code]....
I am trying to determine if I should upgrade PHP's PEAR on my server. I am trying to check the version of PEAR currently installed. I am getting the following error when I use the pear -V command:Warning: realpath(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s)(/usr/share/pear:/usr/share/php) in System.php on line 459I tried adding /tmp to my php.ini file, but then when I use the pear -V command it doesn't do anything. I do not get any errors or anything.I am also trying to install symfony and have the same situation described above when I use the following command: pear cannel-discover pear.symfony-project.comDoes anyone have any thoughts? If not the solution, does anyone have any suggestions on how to begin troubleshooting this?
View 2 Replies View RelatedI'm trying to execute a C++ program on PowerPC. But I am facing an error saying: "error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory". But a C program gets executed successfully. The programs are cross compiled using PowerPC cross compiler.
View 1 Replies View Relatedwhat is the translation table and referance table in any DB (with referance to Data conversion)
View 2 Replies View RelatedWhere can I put commands which should be executed just before
- logoff
- shutdown
I think there must be somewhere an opposite script to
.initrc
or
.bashrc
I am using Messenger on Acer Aspire One and i only just realized that when i am on web cam/ video call people can hear me.
View 3 Replies View Relatedi have new build testing centos 5.4 i386 base how to monitor logs and watch what is going wrong with file. i have 1 zmanda server enterprise i give permission and when i excecute nothing happend
# chmod +x amanda-enterprise-3.0-installer.bin
-rwxr-xr-x 1 root root 0 Mar 6 12:12 amanda-enterprise-3.0-installer.bin
# ./amanda-enterprise-3.0-installer.bin
what i am missing to install it.
ssh - execute the script remotely / File not found: ''I am uisng amazon ec2-api-tool & ec2-ami-tool
i was unable to execute through ssh. Getting error as File not found: The same script i can able to run directly in client machine successfully. Through ssh i was uanble to run the script remotely Source : myScript.sh ec2-create-volume --size $1 --availability-zone $2 $ssh -i key.pem root@myhost ./myScript.sh 10 us-east-1a In remote machine i have permission for myScript.sh as -rwxr-xr-x
Note:Reference link
1) How to create an ebs image from an existing ec2 instance
2) Building EBS Boot and S3 Based AMIs for EC2 with Ubuntu vmbuilder - Alestic.com
I want to install Codendi softwr to my Centos 5.3.But can not execute the installation script gives an error permission denied./etc/fstab file does not contain a path that holds my CDROM drive.
View 2 Replies View RelatedIs there a way to alter the default position that windows open such that if I have an application that I want to open (for example) with the lower right corner in the lower right corner of the screen or in the middle of the screen, etc, this can be done automatically? In KDE it can be done by right clicking and adjusting application properties. I don't see how to do that in Gnome. I'm using Fedora 13 with Gnome.
View 2 Replies View RelatedI combined two mp3 files into one using VLC and the whole thing plays but it still shows as being only the length of the first song. So, the mp3 actually plays for 6:12, but it shows as being 3:37.
View 4 Replies View RelatedBasically ubuntu 10.04 did an upgrade about a month ago, since then, GNOME has been playing up - it just displays in the default 'theme' rather than the one ubuntu style i choose.
secondly, there is no facility to manage the windows on screen - by that i mean to close minimise/maximise windows or even drag them round the screen as the 'border' around the application isnt there.Im using xfce as a workaround at the moment , but would like to get GNOME sorted if possible for what its worth this is on my compaq nx9005 laptop, upgrades at the same time on my main pc didnt suffer the same fate.
In the comments section of this blog, the commenter "Pratik" claims that you can edit a running bash script, without killing it, and have the changes picked up by the running script. He claims you can do this by editing files in /proc. Now, I know how to find the /proc folder that contains the data on the running process, Code: cd /proc/`pgrep process_name` But I can't figure out what I should do if I want to edit a running bash script.
View 6 Replies View Relatedwhat the correct way is to add '/sbin' to my users environment path which is not present when I run the command 'env'?
Code:
carlos@db1:~$ env
TERM=xterm
SHELL=/bin/bash
SSH_CLIENT=192.168.1.115 35495 22
SSH_TTY=/dev/pts/0
[code].....
I would like to add /sbin to all future user's I create with 'useradd' and including my already existing user account above. Can someone tell me the correct way in Debian to change my current user environment to have /sbin in their path as well as how to add this for all future users? I looked at /etc/profiile and there are two lines that look relivant:
Code:
if [ "`id -u`" -eq 0 ]; then
PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
else
[code]....
I'm guessing the 2nd PATH line is for users and the 1st one is for root, right?
I have just got an Nvidia GT240 card and have for the first time set up dual monitors (An LCD @ 1024x768 and a projector @ 1152x864) I have them set up as twinview so I can drap/drop between the two and run compiz across the two. My problem is in running some games (Hedgewars, Powermanga, I have no tomatoes) These games run full screen and currenlty span the two monitors which is not workable as they are not side by side and run different resolutions. How can I tweak these apps to run on only one monitor without altering the xorg.conf and losing the functions mentioned above? I have found a resolution setting in Hedgewars but it only give one option and does not allow me to overtype it.
View 4 Replies View Related
