Re: error 29, file not found (errcode: 13)

I followed the manpage for mysqlimport: thufir@dur:~$ thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using password: NO) thufir@dur:~$ thufir@dur:~$ thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT,

Re: Optimizing InnoDB tables

Have a look at this: https://rtcamp.com/tutorials/mysql/enable-innodb-file-per-table/ -- Andre Matos andrema...@mineirinho.org On Jun 25, 2014, at 2:22 AM, Antonio Fernández Pérez wrote: > ​Hi again, > > I have enabled innodb_file_per_table (Its value is on). > I don't have clear what I sho

Problem with INSERT INTO and UPDATE queries

​Hi list, I have some problems with INSERT INTO and UPDATE queries on a big table. Let me put the code and explain it ... I have copied the create code of the table. This table has more than 1500 rows. ​Create Table: CREATE TABLE `radacct` ( `RadAcctId` bigint(21) NOT NULL AUTO_INCREMENT,

Re: Optimizing InnoDB tables

- Original Message - > From: "Antonio Fernández Pérez" > Subject: Re: Optimizing InnoDB tables > > I have enabled innodb_file_per_table (Its value is on). > I don't have clear what I should to do ... Then all new tables will be created in their own tablespace now. It's easy to convert a