Cleaning ES3 MySql database  Topic is solved

Discussion and help for Easy Save 3

Cleaning ES3 MySql database

Postby nFighter » Fri Dec 07, 2018 1:09 am

I just saw that in a year my database grow up quite big. Is there some way to make a cleaning using native ES actions? Something like delete cloud files by mask, or get the list of all files from mysql (so I could sort the unused one and delete them)?

I understand that it's an easy task for a simple MySql query, but It need to be synced with Unity's data so it's actually quite tricky in my case :roll:
nFighter
 
Posts: 25
Joined: Thu Apr 12, 2018 7:15 am

Re: Cleaning ES3 MySql database

Postby Joel » Fri Dec 07, 2018 10:37 am

Hi there,

As data can only be deserialised in Unity, you would need to download each piece of data and determine yourself whether a particular piece of data needs deleting.

To get a list of all files from the server, you can use the ES3Cloud.DownloadFilenames method.

All the best,
Joel
Joel @ Moodkie Interactive
Twitter - Unity - LinkedIn
User avatar
Joel
Moodkie Staff
 
Posts: 2626
Joined: Wed Nov 07, 2012 10:32 pm

Re: Cleaning ES3 MySql database

Postby nFighter » Fri Dec 07, 2018 1:51 pm

Perfect! Got it! it's a playamaker's ES3 Cloud Download Filenames Action in my case!
nFighter
 
Posts: 25
Joined: Thu Apr 12, 2018 7:15 am

Re: Cleaning ES3 MySql database

Postby nFighter » Sun Feb 03, 2019 8:02 pm

Sorry for opening the old topic, but I believe something goes wrong.

I just run the action with my URL/API and it returns me an array with 29 files. But actually my database have more than 3 thousand files... :?
Image
nFighter
 
Posts: 25
Joined: Thu Apr 12, 2018 7:15 am

Re: Cleaning ES3 MySql database  Topic is solved

Postby Joel » Mon Feb 04, 2019 7:13 pm

Hi there,

I've had no other reports of this, and unfortunately it's not possible for me to tell what is happening without replicating it at my end. Please could you send me a very basic project which replicates this?

Also, assuming it contains no sensitive data, please could you PM me a dump of your MySQL data as a .sql file so that I can recreate the database at my end and understand what is happening?

All the best,
Joel
Joel @ Moodkie Interactive
Twitter - Unity - LinkedIn
User avatar
Joel
Moodkie Staff
 
Posts: 2626
Joined: Wed Nov 07, 2012 10:32 pm

Re: Cleaning ES3 MySql database

Postby jp1976 » Fri Sep 13, 2019 9:54 am

Hi both,

I've had the same error with my project - using ES3Cloud.DownloadFilenames returns only 21 rows where as my database has 36.

Any thoughts/solutions?

A regular PHP statement "$data = $db->query('SELECT filenames FROM tablename')->fetchAll(PDO::FETCH_COLUMN);" returns all 36 rows.


Thanks,

James.
jp1976
 
Posts: 1
Joined: Fri Sep 13, 2019 9:50 am

Re: Cleaning ES3 MySql database

Postby Joel » Fri Sep 13, 2019 5:51 pm

Hi there,

This issue was fixed a few updates ago, so updating from the Asset Store should solve your issue. You should also check you're using the latest ES3Cloud.php on your server.

All the best,
Joel
Joel @ Moodkie Interactive
Twitter - Unity - LinkedIn
User avatar
Joel
Moodkie Staff
 
Posts: 2626
Joined: Wed Nov 07, 2012 10:32 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 2 guests