Posted
by ming yeow
on Stack Overflow
See other posts from Stack Overflow
or by ming yeow
Published on 2010-05-20T01:19:40Z
Indexed on
2010/05/20
1:30 UTC
Read the original article
Hit count: 213
I truncated several huge tables, but the mysql file and database appears to remain at the same size.
Does truncate table delete the data from mysql as well?
© Stack Overflow or respective owner
as seen on Ask Ubuntu
- Search for 'Ask Ubuntu'
I tried everything till now:
sudo apt-get remove mysql-server mysql-client mysql-common
sudo apt-get purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
and even more commands...
But whenever I am trying to locate mysql. I get a no. of files related to mysql
command:
shell>>…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Mysql was started:
/usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
but when I'm trying to do something:
ERROR 1548 (HY000) at line 1: Cannot…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin.
As far as I can tell, the only copy of MySQL…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Can't start mysql with:
sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700
120222 13:40:48 mysqld_safe Starting mysqld daemon with databases…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
This is very common concept that truncate can not be rolled back. I always hear conversation between developer if truncate can be rolled back or not.
If you use TRANSACTIONS in your code, TRUNCATE can be rolled back. If there is no transaction is used and TRUNCATE operation is committed, it can not…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Download the Script of this article from here.
On December 11, 2010, Vinod Kumar, a Databases & BI technology evangelist from Microsoft Corporation, graced Ahmedabad by spending some time with the Community during the Community Tech Days (CTD) event. As he was running through a few demos, Vinod…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I currently have a Postgres 8.4 database that contains a varchar(10000) column. I'd like to change this into a varchar(255) and truncate any data that happens to be too long. How can I do this?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm trying to truncate a table with Spring:
jdbcTemplate.execute("TRUNCATE TABLE " + table);
Get the error:
Caused by: org.springframework.jdbc.BadSqlGrammarException:
StatementCallback; bad SQL grammar
[TRUNCATE TABLE RESULT_ACCOUNT];
nested exception is
java.sql.SQLException: Unexpected
…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Using MSSQL2005, Can I truncate a table with a foreign key constraint if I first truncate the child table(the table with the primary key of the FK relationship)?
I know I can use a DELETE without a where clause and then RESEED the identity OR
Remove the FK, truncate and recreate but I thought as…
>>> More
