Forum Discussion
Dealing with huge database
Hi, I'm dealing with a 2tb database and have tried few times to load it but end up unsuccess. What can i do with it?
Anonymous,
Do you need all the columns of your database? I would recommend you specify required columns using SQL statement like "select col1,col2 from mydata.link_bi_betslips limit 5", and enter timeout value.
Regards,
Lydia
Anonymous,
You can input SQL statement in the highlighted textbox. You can firstly test the SQL statement in MySQL workbench,
Regards,
Lydia
Anonymous,
I was still unable to extract any data with my sql statement below
Anonymous,
Do you need all the columns of your database? I would recommend you specify required columns using SQL statement like "select col1,col2 from mydata.link_bi_betslips limit 5", and enter timeout value.
Regards,
Lydia