I have a script and there are some modifications that I want to make
In the instructions it says ALTER TABLE and CREATE TABLE in myqsl but I dont know exactly how to do this.
I have tried to google but everything i find is very technical and doesnt explain the easiest way to do it.
Should I use phpmyadmin or whats the correct way?
mysql: Copying to tmp table, what causes that?
My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.
Table '231_message' is marked as crashed and should be repaired
I haven't ever had this happen, is all my data truely lost or can i 'repair' it
i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )
either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database
I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..
1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?
2.- Should I repair it using phpmyadmin or just from the shell?
3.- Should I stop http traffic during this optimization?
This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:
Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2
[mysqldump]
quick
max_allowed_packet=16M
[mysql.server]
user=mysql
#basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log
On the other side, i have the same hardware for the webserver..
I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.
View 4 Replies View RelatedI have a server with many db on mysql 5
Any db contains 5 table with data
This data is processed by routine
Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"
The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..
what I can do about the following database error in mysql?
Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it
I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.
How can I disable INSERT access to specific table.
The user should have full access the the DB except insert to specific table.
The tables_priv allow to set what enable and not what disable.
I'm using mysql v5
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies View RelatedI would like to change the alias host from webmail.domain.com webmail to domain.com/webmail.
View 1 Replies View RelatedIn Plesk 12.0.18 #4 I checked Grant the ALTER DATABASE permission to all Microsoft SQL Server database users . The problem is I cannot rename database tables or other functions with myLittleAdmin for SQL provided with Plesk.
My question is: Am I doing something wrong or is needed to upgrade the myLittleAdmin license to Full version?
I always have this error with mysql
Can't create/write to file '/tmp/#sql_7042_0.MYI' (Errcode: 13)
the /tmp has been chmoded 1777. I installed mysql downloaded from rpm on www.mysql.com, version 5.0.51a 64bits for CentOS-5
Is there any way to create a cron to backup mysql data daily ( or weekly )? I mean an "auto script" to run this command daily
mysqldump -u usernam -p password dataname > file.sql
one of my site shows this error
MySQL Error: Can't create/write to file '/dev/shm/MYxQT8lz'
I checked space on the server is still 25 GB free,
I freshly installed Plesk 12.0 on Ubuntu 14.04. Everything works accept the MySQL database creation.
When I try to create one, i get this error :
error: the test connection to the database server has failed because of network problems: connection refused...
why this mysql command doesn't work on phpmyadmin on cpanel server.
Quote:
CREATE VIEW TEST AS SELECT * FROM COURSE
it give this error:
Quote:
#1064 - 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 'VIEW TEST AS SELECT * FROM COURSE' at line 1
Customer has requested the following:
"Create a zend id for your machine." This is apparently for them to create a product key for their software and have to bind to it?!
I have never heard of this and have been unable to locate any information on it.
This is a Centos box with php 5.2.5 installed:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
how to go about this or even what this is?
Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.
Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:
SQL query:
OPTIMIZE TABLE
MySQL said:
#1064 - 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 '' at line 1
Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?
Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?
I have a site running on vps and the attachment table got crashed , I am unable to repair it :
thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK
This is result of repairing from WHM, how to repair it?
i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci
[mysql.server]
user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
On my new unmanaged VPS i keep getting mass emails sent to me saying -
iptables v1.2.11: can't initialize iptables table `filter': iptables who? (do you need to insmod?)
Perhaps iptables or your kernel needs to be upgraded.
Im a bit of a n00b when it comes to unmanaged servers, just wondering if anyone knows whats wrong and how to fix.
I have a table that is showing
MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)
I've repaired it via
mysqlcheck --repair --all-databases
that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.
I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.
It's like there is a table where this data is kept, but I've looked and can't find anything.
I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?
View 4 Replies View RelatedFrom Linux Shell, I need to back up a mysql database, JUST the data, NO Table information. Which options in mysqldump do I use?
View 14 Replies View RelatedI am unable to mount the 2nd disk's extended partition. Please help.
Commands I tried and returns....
Quote:
mount -t ext2 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Quote:
mount -t ext3 /dev/hdd2 /second
mount: wrong fs type, bad option, bad superblock on /dev/hdd2,
missing codepage or other error
In some cases useful info is found in syslog - try
dmesg | tail or so
Also I tried to add it to /etc/fstab but it says the same error, Disk /dev/hdd2 doesn't contain a valid partition table... I am able to mount /dev/hdd1 successfully.
In the forum [url]suddenly we got Internal Server Error. Our host claims it is because of corrupted database accorind the logs:
081128 11:44:38 [ERROR] Got error 126 when reading table './lykman_clubcento/lykman11_members'
Repairing the database from cpanel didnt work. Old available backups are not available.
ip_conntrack: table full, dropping packet
What does that error mean? It's related to iptables right? When I do this cat /proc/sys/net/ipv4/ip_conntrack_max, I get
65536
I increased it
131072
Because someone recommended me this number because I have 4gb of RAM. But I still get the table full errors or
host kernel: printk: 500 messages suppressed
What should I do? Should I keep increasing the number? How do I know how much I can increase it by?