Multiple blank images with no data. New post.
Re: [Multiple images with no title](no size)
I,m a noob at mysql so I have a question for the community. We are running Fog 1.2.0 on Ubuntu 14.04 LTS.
My question is how do i get to the sql interface to run the command " DELETE FROM fog.images WHERE imageName IN (’’,NULL);" ?
We also had multiple blank images start populating our database, seems to have stopped at 32,205 count. Any help would be appreciated. Thanks!
Thank you so very much that solved our problem!! We are a school district in Texas and this was slowing things down a bit.
Switch to root properly by typing
Then, access mysql by first calling MySQL
If MySQL is password protected, it’d instead be
mysql -u root -p,press enter, and then supply the password.
Then switch to the fog database by typing
Run your commands:
DELETE FROM fog.images WHERE imageName IN (’’,NULL);
To quit MySQL when you are done, type