Tag Info

New answers tagged

3

Assuming that your dataset is larger than your buffer pool, having it at 95% usage is not only normal, but a desired state. You want as much information as possible on memory- hardware and resources are there to be used- so that both next reads and writes can be done faster than having to access disk. A different thing is if that memory usage is being used ...


0

MySQL Workbench is primarily a tool to work with the MySQL database server and hence all implemented migrations ultimatively use MySQL as target. No other target is supported.


0

MySQL Workbench doesn't have that capability. However, migrating away from MySQL is probably one of the easiest RDBMSs migrations possible. Migrating data is easy- just export in CSV format and import to the desired target, or use ODBC as a compatibility layer. The complicated thing is something common to any migration- porting the schema, server-side ...


0

Having researched and tested out a few ideas I have now found a solution. 1) Access or Excel and utilise VBA to Save the CSV files to the FTP of where your website is. 2) After the SaveAs VBA statement I then had another line of code that fires open a web browser which loads a PHP page and executes a INSERT with LOAD DATA LOCAL INFILE... Even with a 50mb ...


1

Scanning the source code of MySQL Workbench you can see a few places where SHOW INDEX is sent out. The application needs to run quite a number of queries for its tasks, e.g. the index view or the table editor. Some of them are only active when you open a view from the management section. Others, like the SQL editor need a SHOW INDEX to find info about PK ...


0

MySQL Workbench allows to migrate data from various source RDBMSes to MySQL (e.g. MS SQL, Access, postgres). Start the migration wizard via the Database menu and select MS Access from the drop down in the source db settings: Continue after that and select your MySQL server you want the data end up. It will set up all meta data for you and gives you 2 ...


0

MySQL cannot reach outside itself for any kind of execution. This would be a serious security problem. Instead, you write script or program that orchestrates what you need. It can reach into ACCESS and either extract the data or create a file. Then the script/program reachs into MySQL to insert the data or have it read the file.


0

The first suggestion was to use the "pager less" command - but as pointed out, even at 10 pages a second, it would take 25 hours to get through 900,000 records. Unfortunately, the "pager" command doesn't work on Windows. It was then suggested to send the output to a file and scroll through that - looking for a disconnect between the .csv input and the ...


0

ALTER TABLE .. ADD COLUMN must copy the table over and rebuild the indexes. This means that it needs about as much extra space as the table requires. It may not seem like the disk ever got full, but it may have, then got freed up when the error occurred. Also, depending on the setting of 'tmpdir', it may be running out of room in the temp directory. ...


0

While the CREATE TABLE is a strange error, and should be investigated further and/or reported to see if the failback operation should be done for Workbench, your real problem is the first one: ERROR 1114: The table 'Analysis' is full This suggests that the engine cannot alter the table because it has run out of space. This doesn't necessarily mean that ...


0

If you have a lot of records in your table, take a look at my answer to a related question here. With respect to MySQL Workbench, I have always found the tool to be excellent. Having said that, what MySQL Workbench 'may' be doing in the background is creating an empty temporary table with the extra field, copying over all the records, the deleting your ...



Top 50 recent answers are included