Server :: ERROR 1146: Table 'information_schema.tables' Doesn't Exist

Jul 13, 2010

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;


View 3 Replies


Server :: Database Table Doesn't Exist [error Code: 1146]

Jun 18, 2010

Recently I got a very rare database issue, it says: Error: Couldn't read status information for table clients_copy () mysqldump: Couldn't execute 'show create table `clients_copy`': Table 'adm_retail.clients_copy' doesn't exist (1146) Error: Couldn't read status information for table dt_mx_emp ()


View 2 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run

GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:


View 13 Replies View Related

CentOS 5 Networking :: Proxy - Error "can't Initialize Iptables Table `nat': Table Does Not Exist"

Aug 19, 2011

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:


View 4 Replies View Related

Server :: Keep Getting "ERROR 1146 (42S02)?

Jan 12, 2010

Im trying to migrate mysql to a new server, the first server is FreeBSD 6.2 and the second server is ubuntu, so I used rsync for that, on ubuntu:show database; works successfully and shows the database imported from the FreeBSD box, show tables; also works, but select data from any didn't work, I keep getting "ERROR 1146 (42S02): Table 'DATABASE.TABLENAME' doesn't exist", although .frm .MYI .MYD are available in /var/lib/mysql/databasename

View 2 Replies View Related

General :: Query Died: Fusername: Table 'rsmembers.User' Doesn't Exist

Nov 5, 2010

I just purchased a new server and loaded it with Ubunut server 10. I installed apache2, php5, and mysql5. apache needs a little bit of configuration left (I need to tell it to accept index.php in addition to index.html), but other than that, all the php is working. MySQL is working as well, at least on the server. If I do a "show databases;", it shows all the databases properly. I loaded phpmyadmin on the server for testing, but I'll be removing it once everything works - this is my production server. phpMyAdmin can find all the tables, perform successful queries, and do everything I want it to, HOWEVER If I try to use the login page, I get the error mentioned in the title of this thread.

The database is a carbon copy from my development server, which works flawlessly. All the php and html pages are exactly as they are on the development server too, yet I still get that error. I've reloaded all pertinent programs (apparmor, apache2, and mysql). Apparmor was because I had to declare some new lines for mysql to access a different location for the DBs I resolved the "can't load InnoDB issue", but this one is stumping me.

View 1 Replies View Related

CentOS 5 :: Execute `alter Table` For A Lot Of Tables?

May 7, 2009

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 View Related

Server :: Change The Webroot Of The Httpd Server - Directory Doesn't Exist - CentOS 5

Jun 1, 2009

I have just configured CentOS server my new office. This is the first time I am using CentOS.

Whenever I am trying to change the webroot of the httpd server, it usually say "directory doesn't exist". whereas which can't be the case as it is home directory of the user.

To achieve this, what Do I need to do?

The second issue, I am facing that whenever I am adding new directories to public_html folder, it is not accessible. as the error page 404 is shown. I have changed the permissions to 0705 and ownership is also transferred to other user. What else is required to make new directories accessible by the web?

View 2 Replies View Related

Slackware :: Error 1146 - Basic MySQL Configuration / Initialization

Oct 22, 2010

Do I have to do a basic configuration / initialization of mysql, like described in the following link, before I can use it? [URL] The background is, that I want to use mythtv and therefore I need a working mysql. When I tried to create the needed database, as described in the file README.SLACKWARE (included in mythtv.Slackbuild package from with the following command, I got an error:
# mysql -u root -p < /usr/share/mythtv/database/mc.sql

The error message was:
ERROR 1146 (42S02) at line 3: Table 'mysql.servers' doesn't exist
-- integrale

I don't remember that I ever did a basic configuration but mysql was already used by joomla, and it worked right out of the box.

View 5 Replies View Related

Server :: Edited The Config Files Because Xx.xx.xx.xx Doesn't Exist?

Aug 25, 2010

I'm taking over as a Linux admin where they use sendmail last week. I've done very little with email on linux, and haven;'t touched sendmail since 2000 so I am really out of my element.Basically the sendmail server for many months has had performance problems, disk, and load.Looking into it I found this doing a tail on /var/log/MaillogAug 25 17:11:49 web8 sendmail[1531]: o7OGF2VH002566: to=postmaster, delay=1+01:58:10, xdelay=00:00:00, mailer=relay, pri=2388694, relay=[xx.xx.xx.xx], dsn=4.0.0, stat=Deferred: []:No route to hostAnd that was all it was spewing, I edited the config files because xx.xx.xx.xx doesn't exist. And running m4, then restarting sendmail.It is still spewing out that message, but I do see some things connecting to the new yy.yy.yy.yy address. I even greped the entire /etc looking for the old machine.

View 2 Replies View Related

Server :: Mysql MyISAM Table Doesn't Have .MYD And MYI Files

Jan 26, 2011

We have a MyISAM table without .MYD and .MYI files for storing data and index but we can select data from the table. We can't use mysqlhotcopy for backup the table. Each time,we execute mysqlhotcopy, we have the following error: 'dbs.table: is not base table'. How do we repair the table to re-create .MYD and .MYI files?

View 2 Replies View Related

Server :: Apache Document Not Exist Error

Jan 31, 2011

I am in the process of migrating my old server into new Linux new server. As part of the , apache configuraton is one of the process . i have installed http with yum. i added some test dir like /date/test underwhich i created one test.html. When i start apache , it says Starting httpd: Warning: DocumentRoot [/data/test] does not exist.i am not sure about it. I have directory exists. however it shows the error message.

View 3 Replies View Related

Server :: Error - 550 Localhost.localdomain Does Not Exist

Jan 22, 2010

We've had this server running before but two hours ago there are some domains outside which we cannot send email to. this is a sample of the message we get


The original message was received at Fri, 22 Jan 2010 14:31:59 +0800 from []

----- The following addresses had permanent fatal errors -----

<> (reason: 550 localhost.localdomain does not exist)

----- Transcript of session follows -----

... while talking to

>>> DATA
<<< 550 localhost.localdomain does not exist
550 5.1.1 <>... User unknown
451 4.4.1 reply: read error from

Our server's been running smoothly before but i dunno what happened. I can send mails to gmail and yahoo as well... but there are like 3 domains which we cannot send mails to.

View 8 Replies View Related

General :: Scp - Error "file Doesn't Exist"

Feb 18, 2010

I'm trying to use scp to get a file from my desktop onto the server for my school. I'm connected via VPN and using PuTTy to try to do this. I've tried every single combination/permutation/help site on the web that I can think of and I still can't get this thing working. This is what I get:

[palermo@matrix hw2]$ scp palermo@matrix:/rhome/palermo/ats652/hw2
palermo@matrix's password: No such file or directory

Yet the file sits, in all it's glory, on my desktop. What have I missed here? This is for a homework due next week, so the urgency is kind of on.

View 5 Replies View Related

Server :: Error : Asr : Invalid Raid Config Table

Nov 11, 2010

I had a RAID controller in a system that would not load Virtuozzo. So I deleted the array created by the 3Ware 9550SX controller before removing it and one drive from the CentOS 4.8 server. Even though I deleted the array when the server boots it shows an error:

ERROR : asr : invalid RAID config table

How can I clear and remove the table without having to reload the OS? Can I? Di I need to run the Seagate Tools and reset the drive?

View 1 Replies View Related

Server :: Error During Bootup: Mount: Special Device LABEL- San_data Does Not Exist

Dec 9, 2010

why I'd be receiving this error. I have created a partition and filesystem and put the label in fstab. Everytime I reboot the server it is unable to mount the filesystem. However I am able to mount it manually.

View 5 Replies View Related

Server :: Creating Domain Form Vadddomain-domain Doesn't Exist

Apr 12, 2011

iam using centos5.2.configured qmail,vpopmail. while adding domain form vadddomain<> At first time domain folder get created in domains directory.and also postmaster user also get created by default.And also in mysql. Now the problem is after some times or rebooting system domain get erased automatic.also in /var/qmail/users/assign file domain name get erased.

View 1 Replies View Related

Ubuntu Installation :: Installer Doesn't Show Partion Tables?

Feb 16, 2010

I am about to make a fresh install of ubuntu 9.10 on my 160gb hdd and keep my home directory. Here I also have Windows XP installed, the swap, home and root. All of these are done manually and given names such as 'sda1', 'sda5' ect.(I do see them in system monitor > file systems) The problem is that the installer doesn't seem to show me these tables. I only get a 160gb big chunk. GParted will not show it either (but as root is running from their I guess it cant?).

View 6 Replies View Related

Programming :: MySQL Error When Creating FK In Tables

Dec 11, 2009

Can't single the cause of the error.

mysql> CREATE TABLE Shipment (
-> Shipment_ID INT(10) NOT NULL,
-> Delivery_ID INT(10) NOT NULL,
-> Customer_ID INT(10) NOT NULL,
-> Driver_Employee_ID INT(10) NOT NULL,
-> Consignee VARCHAR(255) NOT NULL,
-> Payment_Method VARCHAR(255) NOT NULL,
-> Payment_Received VARCHAR(1) NOT NULL,
-> FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
-> FOREIGN KEY (`Customer_ID`) REFERENCES `Customer`(`Customer_ID`)
-> FOREIGN KEY (`Driver_Employee_ID`) REFERENCES `Driver`(`Driver_Employee_ID`)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (`Delivery_ID`) REFERENCES `Delivery`(`Delivery_ID`)
FOREIGN KEY (`C' at line 10)

View 4 Replies View Related

Debian :: No - Doesn't Exist ?

Aug 17, 2010

I was just trying to get the now playing for banshee to show on conky but the way I was going to do it required me to make a wrapper for but I can't seem to find it or it doesn't exist.

View 4 Replies View Related

General :: Why Would Executable Say It Doesn't Exist / When Try To Run It?

Sep 28, 2010

I have a compiled program, a tagger to identify parts of text, which claims it does not exist.This executable has to be called by a generated script, which is how I ran into this issue. What are the reasons this error could show up?The executable was copied from another machine.The file does have execution privileges (it gives a proper not-allowed message without them)I've tried copying the file to a different location (same problem)I've tried replacing the file with a fresh copy (same problem)The file does exist. Opening it with pico shows a file with binary data.

View 4 Replies View Related

Server :: MySQL Permissions - Copy Tables From One DB To Another

Jun 14, 2010

I am using Joomla and a script within it. That Script is suppose to copy tables from one DB to another.

Error(1) [1142] query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
Error [1142] retrying query [CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`]. DB Error: CREATE VIEW command denied to user 'localiz_master'@'localhost' for table 'test_users' SQL=CREATE OR REPLACE VIEW test_users AS SELECT * FROM `localiz_master`.`jos_users`
localiz_master: name of the DB from which data is suppose to be copied.
jos_users: name of the table form the main DB.
localiz_master: user for the DB.
localhost: host
test_users: name of the table to be created.

We do have phpmyadmin but the user's table is hidden. What SSH command we might run to make localiz_master user have access to all the databases.

View 6 Replies View Related

Debian Configuration :: Icedove Doesn't Seem To Exist

Apr 11, 2016

I have had to revert my VM to a previous image (did something to screw it up) anyway I have to reinstall icedove into my VM and I noticed after doing: sudo apt-get update && sudo apt-get install icedove that icedove can't seem to be found in the libraries anymore and simply wont install.

View 14 Replies View Related

General :: Can't Believe That Program That Does Same Thing Doesn't Exist

Sep 14, 2010

For our class project we are going to use HyperTerminal to communicate to something we are building that is attached to our laptops using USB. We're supposed to use HyperTerminal.URL...I can't believe that a program that does the same thing doesn't exist in Linux. What programs that can do the same thing are available in Linux and Mac OSX?

View 5 Replies View Related

Ubuntu :: Alert /dev/disk/by-uu... Doesn't Exist?

Apr 30, 2011

long story, I upgraded my system from maverick to natty, didn't like it so restored my system with a backup that I had done recently. after it rebooted I used gparted live CD to expand my partition, moving swap to the end of the HD, then when I rebooted grub didn't work so I booted with ubuntu live cd and reinstalled grub. then I booted normally but nautilus didn't work and had lots of problems. So I installed ubuntu again with ubuntu live cd, formating the partition and expanding it, no problems at all.But, I wanted my files back, so restored the system again, now the message that I get isQuote:

Gave up waiting for root device. Common problems:
-Boot args (cat /proc/cmdline)
-Check rootdelay= (did the system wait for the right device?)


View 9 Replies View Related

Fedora :: Why Config.h File Doesn't Exist

Jul 30, 2010

i was assigned with a project to analyse the performance of ASSP mail filter engine.I am using Fedora 7 with KDE3.5. I need to install a lot of perl modules to run the code.I was trying with all sorts of packages like src.rpm, ixxx.rpm, tar.gz, tar.bz2. All these packages doesnt work exactly. When i tried with rpm packages. I am getting this error.

[root@localhost RPMs]# rpm -ivh cyrus-sasl-2.1.23-9.fc12.src.rpm
warning: cyrus-sasl-2.1.23-9.fc12.src.rpm: Header V3 RSA/SHA256 signature: NOKEY, key ID 57bbccba
1:cyrus-sasl warning: user mockbuild does not exist - using root


So i checked for config.h file as given the directory but it was missing.I don't know why?

View 4 Replies View Related

OpenSUSE Multimedia :: Folder Vdpau Doesn't Exist?

Jul 4, 2010

mplayer complains about not being able to find I checked in /usr/lib, and it's there, but it's a link that points to /usr/lib/vdpau The folder vdpau doesn't exist.

Which package do I need to install to get this to work?

View 4 Replies View Related

Ubuntu Installation :: 10.04 /dev/md0 Doesn't Exist When Grub2 Tries To Access It

May 1, 2010

I have installed Lucid Lynx more than a dozen times in the past thirty hours and I've almost got it working with RAID. The current problem is with /dev/md0 not existing when grub2 tries to access it. When I boot from the alternate CD in rescue mode, Ubuntu sees /dev/md0 as a software RAID array and I can access the files accordingly. When I boot from the grub2 bootloader, it sits for a while before spitting out "Gave up waiting for root device" and tossing me into the initramfs shell where I can see that /dev/md0 doesn't (yet) exist. What can I change within grub2's configuration to inspire it to start /dev/md0 before trying to mount it?

View 6 Replies View Related

Ubuntu :: If Xorg Doesn't Exist - What Handles Video

Jul 5, 2010

My laptop has an Intel video card. Does Intel have open source drivers that are included in the kernel? I'm kind of curious because I do not have a xorg file, and I did not install any drivers as I had to on my nvidia desktop, yet all of my maximum resolutions come down accordingly.

I'm just curious on what exactly controls the video settings if xorg isn't in the picture.

Also - what relevance does the Fn keys have that probe for a 2nd monitor to Ubuntu? For example, I do not have a 2nd monitor attached, but if I hit Fn F8 over and over, sometimes it changes my resolution. Why is this? Why would that revert my resolution?

View 9 Replies View Related

General :: Slackware 13 Sessions Command Doesn't Exist?

May 24, 2010

I'm running Slackware 13 - xfce4 and I got a new session in background. How could I see that session and use it? In backtrack I'm doing it via sessions in terminal but im Slackware 13 session command doesn't exist.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved