Cannot import advance racecards SQL files into smartform database

Question

Hi,

I have successfully imported all SQL files into my mySQL database, except for three... which don't appear in the tables list:- additional_data.sql, advance_racecards.sql, advance_racecards_beta.sql.

The import operation, via the command line, appears to complete without error, but on refreshing the database, the tables don't appear. I have re-downloaded the files and re-tried without success. 

(FYI - I'm using DBeaver database tool to interact with the smartform database)

Could you advise please?

Thanks

Answer 1

Hi - first thing to check is that the load procedure was the same for these files with the same username and DB specification; are they possibly installed in a separate database or for a separate user ?

Comments

I have used the same load procedure for every SQL file - MYSQL_PWD="smartform" mysql -u smartform smartform < advance_racecards_beta.sql

---

There's no reason the additional tables should not load in the same way.  Are they fully downloaded, have you checked the size of the files, using the same path etc?

---

I've realised my mistake! The files have loaded correctly - I was looking for tables with names advance_racecards rather than advance_daily_races.
Apologies for the confusion :-)

---

Great - thanks for following up.  That was going to be the final suggestion, to ensure the correct tables were being searched for.  Any other issues let us know.