The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
36 views

update time and create time of tables is showing null in mysql

The columns update_time and create_time is having the value NULL in the information_schema Tables of MYSQL. How can the value be NULL?. Can anyone please explain?
1
vote
1answer
31 views

Innodb tables not showing

If I run query show table in mysql console, the innodb tables will be listed. But when I tried a query like select * from tablename, it says table does not exist. How can I fix this issue and make ...
0
votes
0answers
47 views

MySQL, Table marked as crashed after vServer reboot

i am using a vServer in a data storage center. Sometimes the host machine is rebooted by data center admins which causes the vServer to be rebooted too. After every reboot the database crashes, the ...
0
votes
2answers
887 views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
2
votes
1answer
135 views

How to View the IP routing table

How can I see ip routes I've added with ip route add default via x.x.x.55 table test1 for example I added 199 test1 and 198 test2 and 197 test3 to /etc/iproute2/rt_tables then I run: ip route add ...
0
votes
1answer
2k views

mysqldump ignore table with wildcard

I need to take a dump of a database containing 50 odd tables of which I want to exclude about 15 odd that have prefix 'exam_' I tried mysqldump --ignore-table=dbname.exam_* and even tried ...
0
votes
1answer
324 views

MySQL Corrupt Table - No Space left - Index File too big

I noticed that one of my servers was running out of disk space, due to heavy MySQL usage. I stopped everything using the database, freed up some space and restarted mysqld. Now, I checked my table ...
2
votes
1answer
2k views

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled ...
0
votes
3answers
2k views

MySQL insert cause high disk i/o wait?

Im getting what appears a lot of wait time when performing large inserts in Mysql. Am I correct in assuming I have a disk I/O problem? Yes I am running Mysql on a VM. Innodb_buffer_pool hit rate is ...
0
votes
1answer
241 views

Dump Just 1 table from SSH

With this command : mysqldump -uuser -ppass dbname > 1.sql You can dump dbname to 1.sql I want a way to dump and restore just 1 table of dbname from ssh and command line
5
votes
2answers
393 views

My table half-exists. Can't drop it

I have a table that is taking up quite a bit of space even though it has no rows. I also dropped it a while ago. When I try to drop it now, it says the table doesn't exist. It shows up in ...
1
vote
2answers
827 views

Mysql 5.5 Defragmentation not reducing the fragmentation percent

We are running OPTIMIZE TABLE , but not seeing any fragmentation reduction. They are as high as 120% to 200%. Am calculating the fragmentation % using this: Data_Free / (Data_Length + Index_Length) ...
1
vote
0answers
235 views

SQL Write table to text file

Is there a simple way to write the returned rows of a select statement to a file? I have found one example where you can write a string to a file in SQL ...
-2
votes
2answers
674 views

My MediaWiki wiki_text table is too big. How to compact/vacuum/purge

I run a MediaWiki wiki page. It uses MySQL. I have just 20 wiki pages and yet the wiki_text table is 45 MB big. I had security holes and spam bots were posting spam wiki pages. I have manually ...
2
votes
1answer
296 views

Will repairing a MySQL table run the risk of data loss?

I recently had a table in my MySQL DB go haywire (part of my Invision Power Board install) which has never happened to me before. If I use the "Repair" tool in phpMyAdmin, will I run the risk of data ...
-1
votes
2answers
536 views

MySQL table “doesn't exist” error

I'm using Windows 7 Ultimate x64. After reinstalling OS copied back whole MySQL data directory to C:/Programdata. But now when i'm trying to open some table from restored db's with Navicat it shows me ...
0
votes
1answer
242 views

oracle 10g tablespace table relation?

Im running "Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production" and trying to get familiar with it. I have created a tablespace und set it online. How do I make sure the next create ...
0
votes
2answers
580 views

How do I rename a mysql table in php?

I have tried all sorts of things to get a table renamed from php, including mysqli (code below) and mysql_connect/mysql_query. I have tried rename table and alter table. In the example below ...
1
vote
1answer
4k views

MySQL table does not exist

I am getting following error in err file. 110803 6:51:26 InnoDB: Error: table `ims`.`temp_discoveryjobdetails` already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm ...
0
votes
1answer
39 views

MySQL Column Constraint

I need a table which will allow to insert values into a column with values greater than 10. When I tried in net, they suggested to create table in following way. CREATE TABLE test ( UID int(11) NOT ...
2
votes
1answer
176 views

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast)

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast) Or can this have impact on the data? Corruption? The table has GBs of data and the server crashed so, now its checking, ...
0
votes
1answer
135 views

Add index to very large SQL Server table

I've got a table with 9 million rows (just received it from our underwriting provider). 4 columns -- leadid (guid), RawLeadXML (nvarchar(max) that contain an xml doc in each row that is 2-3kb), ...
0
votes
3answers
343 views

mysql spitting lots of “table marked as crashed” errors

I have a mysql server(version: 5.5.3-m3-log Source distribution ) and it keeps showing lots of 110214 3:01:48 [ERROR] /usr/local/mysql/libexec/mysqld: Table './mydb/tablename' is marked as crashed ...
20
votes
3answers
11k views

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement because I use it to create the table on an remote server ...
0
votes
1answer
125 views

How to search MySQL table for duplicates

In MySQL, I have a table named "city" with "city_name" and "latitude" and "longitude" in it. It appears that I have a few duplicates. What query can I run (in phpmyadmin) that will search through the ...
0
votes
2answers
97 views

Leftmost column of Multi-column index not functioning as single column index

I was under the impression that an index like CREATE NONCLUSTERED INDEX IX_Name_Age ON People ( Name ASC, Age ASC ) would be used not only for a query like Select * From People WHERE Name = ...
5
votes
2answers
746 views

Does resizing a column lock the table?

What happens if I change a column from nvarchar(2) to nvarchar(10) or a column from char(2) to nvarchar(10). Does this lock, reorganize the table or does this work without any impact or downtime? I ...
0
votes
1answer
26 views

How do I Create an AutoCounter Column in a Table in SQL 2008 R2?

There is nothing in the "Data Type" drop-down that indicates an auto-counter. I selected int and I am assuming there is a setting somewhere else to turn it into an auto-counter. The idea is to have a ...
0
votes
1answer
727 views

Stick table configuration for url-based matching with HAproxy

I am interested in using haproxy for load-balancing with sticky session support, but using stick tables directly to benefit from upcoming master/master stick table replication in haproxy 1.5. As a ...
0
votes
1answer
101 views

Repair all mysql tables on localhost

I have a whole bunch of mysql databases which seem to have corrupted tables which is a bit of a worry. Repairing them on one site fixed all the issues for that site, but is there a way of repairing ...
0
votes
4answers
7k views

How Do I Restrict Views of a Custom List by Group in Sharepoint 2007?

I'm pretty new to Sharepoint and what I would like to do is create a huge master list of all our employees and then make different "views" on that person depending on the persons group For example: ...
0
votes
2answers
137 views

How do I export table “practices” from db1 into db2? How do I do all tables from db1 into db2? Mysql

How do I export table "practices" from db1 into db2? How do I do all tables from db1 into db2? With Mysql, fill in the blank. What do I type at the prompt: Mysql>
0
votes
2answers
297 views

SQL Server 2008 Express, need to copy a table from one server to another automatically

We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
1answer
1k views

phpMyAdmin and linked/relation tables question

I'm trying to set up phpMyAdmin to use linked tables. I've set up the pma tables and have pointed one field - fromid - to the ID of another table - id. When I edit a row from the first table, next to ...
2
votes
1answer
432 views

Can I use the export/import data in SQL 2008 with FK constrained tables?

For sending data back and forth between tables having identical schema I have used the import/export task in management studio. The problem is that SQLServer seems to do the import/export ops in ...
2
votes
1answer
2k views

Page table fast growth

Not long ago I've spotted very interesting tool RamMap. I found on several servers running our x32 software that PAGE TABLE grows very quickly – 1.2 GB per day (of 10GB all). Also NONPAGED POOL grows ...
0
votes
1answer
90 views

MySQL on a laptop for remote workers - MyISAM keeps corrupting

We have an application that is used by remote, mobile workers. It intalls WAMP (Server2Go) on a laptop and uses MySQL to store data locally. All tables are MyISAM. Once a day, the workers sync the ...
4
votes
2answers
3k views

repair partition table

Hallo. I've just overwritten my partition table of my system's hard disk. i made a cfdisk on the wrong device (/dev/sda instead of /dev/sdd), deleted all partitions, made one new primary spanning ...
6
votes
1answer
5k views

Change collation of a MySQL table to utf8_general_cs

I tried to change collation MySQL table to utf8_general_cs but got following error: mysql> ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE 'utf8_general_cs'; ERROR 1273 (HY000): ...
2
votes
2answers
325 views

Creating sphinx table in mysql crashes mysql - why?

I've got the latest version of sphinx installed. I have created the index with no problems and searchd starts up with no problems. However, whenever I try to create a test table (straight from the ...
4
votes
4answers
7k views

Moving a table to a different schema in Oracle

How do I move a table from one schema to another? It's a fairly large table, so the following query would take ages to complete and need huge disk space: CREATE TABLE newschema.mytable AS SELECT * ...