I have the production server online bya provider, and no chance to have an ssh login.
I have a local webserver onwhich i would like to synchronize the Mysql database.
No way to set up MySQL replication for the above restriction.
Then i decided to create a shell script on my local wsebserver that i ìll add in cronjobs once i get it running proper way.
The problem is that whe i launch :
mysqldump -h remoteIP -u user -ppassword > mylocalcopy.sql
the online server will be busy transferring the dump to my local webserver
(i'm talking of a sql file that weights 150MByes)
the consequences are that the online server will lock tables... and not only...
the online website won't be responding ofr the whole transfer duration...
giving an error Service Temporary unavailable.
ANd getting mysql errors such like: User xxxx already has more than 'max_user_connections' active connections in query: Select.....
So apart thinking to launch the dump cron job in a hour with low traffic...
is there a way to not locking the tables?
ANd second... why should the server go down like that giving such error?
Should i think there's any issue with my provider?
Many Thanks ...
