Server :: Repairing A Corrupted Mysql Table On A Shared Hosting?
Feb 21, 2011
i was trying to do some maintenance on the database and i have the following problem when looking at the database with phpmyadmin on the site
Code:
Table Ation Records Type Collation Size Overhead
uc_order_products_pair_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -
uc_order_products_qty_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -
uc_order_products_user_vw Browse Structure Search Insert Empty Drop ~01 View --- unknown -
[Code].....
View 2 Replies
ADVERTISEMENT
Jul 22, 2011
We planned to buy new server for our company, which processor is best for, shared hosting , and nearly 300 clients are going to access this server, all live video streams websites are going to hosted in this server. so which processor is the best option to go,i found these are the best in this which processor give best performance forshared hosting.1. Dual Xeon E5405 2.0Ghz2. Dual Xeon E5130 2.0Ghz3. Core i7 2.66-2.93Ghz
View 3 Replies
View Related
Sep 27, 2010
I have a client that is looking for a way to archive their email (making it searchable, etc) -- all on a shared hosting account.
I was kind of thinking of having some way to parse/store email in a MySQL database and make it searchable using a PHP application. But I'm not sure how to parse the headers (if it's even possible to do so).
Any other ideas on this type of application? They are wanting a way to archive email, make it searchable, keep a record of all emails sent, etc. They're willing to "purchase" a mail server if necessary. But I'm hoping to find a way that they won't have to.
View 1 Replies
View Related
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
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
View 13 Replies
View Related
Aug 7, 2009
I have 2 servers, 1 running a web server on 1 IP address,the other server running a proxy on a different IP address. I intend to change and update the ncsa file with usernames and passwords from a mysql table.Is there a way to replicate 1 table from the webserver to the proxy server databases and then run a cronjob? The cron will simply delete unused usernames and add new ones.Is there a better way of doing this? I don't want to run the webserver on the proxy server for security and also for performance.
View 2 Replies
View Related
Jul 6, 2009
When a user logs into my webmail application, it creates entries in a table on MySQL called "identities" which works great however once the user is deleted fro Linux with the "userdel -r" command, the data still sits in MySQL. My question is how I can I remove the table data from old users? It appears as show below:
[code].....
View 1 Replies
View Related
May 3, 2010
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]....
View 2 Replies
View Related
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
Nov 16, 2010
we had a CENTOS 5.5 x86_64 machine with 8ered with MySQL 5.0.91-community.Currently we had a very high number of Created_tmp_disk_tables (31k in 4,5 hours!!!).I've read suggestion that we need to increase tmp_table_size, and we've set tmp_table_size to 64M, but this drupal modul's query still cause mysql create tmp table on disk
Code:
SELECT DISTINCT node.nid AS nid,
comments.subject AS comments_subject,
[code]...
View 4 Replies
View Related
May 27, 2010
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)
View 2 Replies
View Related
Aug 18, 2011
I have designed name based virtual hosting in apache. as of now,I am able to access website using IP also. which is I am looking to block, only can access by the name
View 7 Replies
View Related
Jul 25, 2010
I have an Ubuntu 9.10 server installation which have been working flawlessly for some months. The server runs bridged networking, because of some VMs that runs on it. But, a couple of weeks ago the network connectivity have started to disappear now and then (usually once a day or so). Running "sudo /etc/init.d/networking restart" always kicks it back to life.
After a bit of debugging I noticed that when OK the routing table looked like this:
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.1.0 * 255.255.255.0 U 0 0 0 br0
192.168.122.0 * 255.255.255.0 U 0 0 0 virbr0
default 192.168.1.1 0.0.0.0 UG 100 0 0 br0
While when in the non-working state it looked like this:
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
192.168.1.0 * 255.255.255.0 U 0 0 0 br0
192.168.1.0 * 255.255.255.0 U 0 0 0 eth0
192.168.122.0 * 255.255.255.0 U 0 0 0 virbr0
default 192.168.1.1 0.0.0.0 UG 100 0 0 eth0
default 192.168.1.1 0.0.0.0 UG 100 0 0 br0
Deleting the two routes to eth0 restores the networking again. Why these "erronous" routes gets added, and what adds them? How to further debug this?
View 6 Replies
View Related
May 13, 2010
So I'm holding my nose and gonna get a shared hosting account. Sorry to sound a snob, maybe I am and tx God there are some of us left! Fact is, I'm a VPS kinda guy but need a shared host for a tech book I'm commissioned to write.
I was with Lunarpages a while off. Thought they were pretty good 'till they lost my db. Not an option. HostGator? Or who? I want cheap as chips. And that's about it. I'll only really be playing with cPanel .. aah, so I need that too. But it would be nice to have some sort of reliability, and I need one of the 'big boys' 'cos many of the target audience for this tome will have that kind of host.
View 1 Replies
View Related
Aug 25, 2010
I'm trying to download one of my .php files from Godaddy's File Manager, and it's not downloading. I AM able to download everything else on the Internet. Maybe a clue is that after I click "download" it says "stopped" in lower status bar.
View 14 Replies
View Related
Mar 12, 2010
This is a USB shared drive, with an ext3 partition. The partition is located at /dev/sdb1. I use Samba to share /media/tiga1000/samba/public, and everyone on the network can add/delete files to it. Specifically, this is our media drive, and we upload a lot of pictures to it, since me and my sister are amateur photographers. Under /public/images/camera_pictures/2010, I have 3 directories. 01_january, 02_february, and 03_march. The directory that has been corrupted is 03_march, and when I say corrupted, I mean that I cannot open it. It acts as a unknown file type that can't be opened.
Here is the file properties of it:
Code:
drsmall@mycroft:/media/tiga1000/samba/public/images/camera_pictures/2010$ ls -lah
total 960K
drwxr-xr-x 4 nobody nogroup 4.0K 2010-03-11 21:22 .
drwxr-xr-x 5 nobody nogroup 4.0K 2010-02-18 20:19 ..
drwxr-xr-x 14 nobody nogroup 4.0K 2010-01-31 11:57 01_january
drwxr-xr-x 10 nobody nogroup 4.0K 2010-02-23 15:47 02_february
-r--r--r-- 1 nobody nogroup 938K 2010-03-11 15:46 03_march
How I should go about recovering it. Somehow it lost it's directory switch. Should I unmount the drive and run fsck on it? I would like to be able to recover these images, if it is at least possible!
View 7 Replies
View Related
Oct 23, 2010
i used to have ubuntu 9.i decided to move to sabayon so i used the live cd to install it ,resize the ubuntu partition and use the remaining space for sabayon.while the resizing procedure i got an error(i dont have a copy of the error log file but i know it has something to do with an anaconda process).i aborted the installation and the result was an filesystem that couldnt be mounted.when i try to mount the hdd i get this:
Code: Error mounting: mount: wrong fs type, bad option, bad superblock on /dev/sdb1,
missing codepage or helper program, or other error
In some cases useful info is found in syslog - try
dmesg | tail or so and this is what i get from fsck: Code: $ sudo fsck -f /dev/sdb1
code....
View 5 Replies
View Related
May 30, 2010
Fascinatingly weird one here. First, this issue isn't on my computer, it's from someone who I am helping. I don't have first-hand access to the computer. Some background: the machine originally had Ubuntu Hardy, which we upgraded to Lucid a couple of weeks ago. Earlier this week, he gave me a call that Ubuntu wasn't booting up; it dropped to the command line. Some tinkering later, I figured out that libgthread-2.0.so had become corrupted, so X wasn't starting. It gave an error complaining that it had an invalid ELF header.I figured that this was just an odd freak occurrence; there was a bad kernel panic previously, so maybe the library was upgraded and the system was just writing to the disk at that time. Fixed via sudo aptitude reinstall libglib.
Ubuntu then started and everything ran perfectly. Today, he gave me a call. After he had restarted the computer, Ubuntu again dropped to terminal at the same point while booting. I had him open a new tty and run startx, which failed with a different shared library but the same error: libXext.so.6 has an invalid ELF header!
We had run updates, but I don't recall whether X's shared libraries were touched. Even if they were, though, that shouldn't affect anything. There were no hard resets between my fixing libgthread and libXext breaking. I'm going to try a clean install; I'm really just hoping we can figure out why this is, because it's an amazing little problem.
View 4 Replies
View Related
Jan 31, 2010
I thought someone might find this useful and not have to lose a day for getting it work... (as I did)...
so this is a Tutorial HowTo based on Virtual Hosting With vsftpd And MySQL On Debian Etch but with modifications needed to work on CentOS 5 (in my case it was CentOS 5.4 x86 32bit).
You will need (if not already installed): yum install vsftpd mysql-server
View 12 Replies
View Related
Oct 5, 2010
What I believe has happened is that I've corrupted the partition table. Essentially one of my partitions' ending point exceeds the maximum number of cylinders/sectors on my drive.
Essentially I have the same problem as on the thread @ [url] but do not know how to fix this and am afraid to reformat/partition based on sectors without really knowing what I'm doing here.
[code]...
When I try to look at SDA in GParted everything shows up as unallocated (though it's obviously not) and it says
[code]...
View 2 Replies
View Related
Sep 23, 2010
I have just run into a baffling error. I have a database set up in MySQL with six tables. My PHP based website performs queries of all kinds on these tables (SELECT, INSERT, UPDATE, DELETE). On my most recently setup table, the "Orders" table, I am able to perform queries from the server, as well as from my PHP MySQL Admin interface, but all activity from my webpage states that the Orders table does not exist. All other tables are running fine. I have tried rewriting the query script, checked for case sensitivity problems, even cut and pasted other working scripts in place, changing the table and field names as needed. No success. What could cause a single table to not show up like this?
View 2 Replies
View Related
Jun 8, 2011
I am trying to install some program: rosinfo: - Create mysql database for rosinfo - Create table hosts, locks. Use file docs/rosinfo.sqlAnd I need to create table hosts, locks, using file rosinfo.sql. I have that file, but dont know what to do with it.
View 1 Replies
View Related
Jul 13, 2011
I've started a webserver at 127.0.0.1:**** I want to be able to use a database for this server. Which schema do I use to add a new table to? Do I create a new Schema altogether?
View 5 Replies
View Related
Oct 17, 2010
A sed mishap prior to a database import left me with a table name with, eh, well, this: Code: mysql> show tables;
+-------------------+
| Tables_in_someday |
+-------------------+
| day20101016 |
| day20101017); |
+-------------------+
I've corrected the sed mishap and imported the database the way it was intended Code: mysql> show tables;
+-------------------+
| Tables_in_someday |
+-------------------+
| day20101016 |
| day20101017); |
| day20101017 |
+-------------------+
But I can't seem to drop the table day20101017); because no matter how I seem to escape it it errors.
View 1 Replies
View Related
Feb 24, 2009
What is the use of UNION=() in CREATE TABLE?
Code:
ENGINE=MRG_MyISAM DEFAULT CHARSET=utf8 UNION=();
I have been given some code and could not explain why it's err's out. Checked the mysql 5.0 manual but nothing[URL]. It only explains using UNION in a SELECT statement which I understand. If I drop off UNION=() then CREATE TABLE works fine.
View 4 Replies
View Related
Jun 7, 2011
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
View 6 Replies
View Related
Feb 18, 2010
I have tried a few packages but cannot find an easy intuitive interface for editing tables in a mySQL database. I just need to simply edit the table field data, import and export multiple rows, and filter the table data so only the rows are returned based on a string that I search for. The tables I edit have several thousand rows and some up to 30,000. I do not know how to write queries and it seems all these packages require that you know how to write sql queries to do what I need to do. On the mac I used Sequel Pro, which is dead easy to use and is mostly point and click to do all the above. Since my mySQL experience is very limited, I really need something simple like this.
I have tried:
MySQL Workbench
Navicat (lite version)
MySQL Query Browser
how to do what I need to do with the above packages.
View 7 Replies
View Related
Mar 12, 2011
I would like to store JPG files in a mysql database table. I figured that using BLOB fields on the one hand and the 'load_file' command on the other would do the trick. Here is how I set up the table:
mysql> create table blobtable (id int(10) not null auto_increment,
fileName varchar(15) not null,
file longblob not null, primary key(id) );
Query OK, 0 rows affected (0.51 sec)
Then I tried to enter the data:
mysql> insert into blobtable(filename,file)values('pic',load_file('/var/www/temp/IMGP4764.JPG'));
Which got me the following error signal:
ERROR 1048 (23000): Column 'file' cannot be null
It seems to me that the file path to the JPG file (although correct) is the source of the problem, and is causing the load_file command not to work. My first attempt was with the JPG file in my PC's home directory. When that returned the same error message, I figured that maybe the file had to be in the PC's (server's) web area so I put it under the 'www' directory.
View 7 Replies
View Related
Jun 26, 2011
I want to insert a acess log file to mysql table.
my log file look like this;
08/Apr/2011 10:51:19 http://v4.netlogstatic.com/v6.00/385...t.messenger.js
08/Apr/2011 10:51:19 http://download.windowsupdate.com/ms...536945da07.exe
08/Apr/2011 10:51:19 http://www.google.lk/search?
08/Apr/2011 10:51:19 http://clients1.google.lk/generate_204
[Code].....
i want to insert this in to a table which having datetime (as it is in log file) and the site visited.
I created a mysql table using DATE using the date type and the TIME suing time type.but once i loaded this log to table date field shows empty. like following.
| 0000-00-00 | 04:18:29 | http://www.espncricinfo.com/navigati...scorecard.css?
how can I solve this problem.your responses are highly. My table should look like the following
| 08/Apr/2011 | 10:51:19 | http://www.radioeksen.com/song.txt
View 1 Replies
View Related
Jul 31, 2010
Making a low-pace instance of Conky on my server, running once a minute and without X-output. and then every minute it inserts a row in a MySQL table with some variables. Once it is in a MySQL database I can make a nice PHP-application showing some graphs and statistics or maybe even send a mail when the motherboard is catching fire or so
View 3 Replies
View Related
Sep 21, 2009
How do you guys to do just that? I know the option for global logging, with parameters --log on service run or log-bin and err-log for inside my.cnf. But what i am looking for is a way to log specifically a table activity, any activity, be it select or update queries.
View 1 Replies
View Related
