Hey I wondering if it is posible and how I can let a php file download a complete dump of an database. someone has acces to import and delete users with it, but I want him to back-up it. That person don't have acces to cpanel.
so the user should click a link and then it will be able to download it the .sql file
thanks in advance
probable youll hav phpmyadmin on yozur account.
so select 'dump', make you configurations and hit the ok button for the first time.
now look in the upper half of the following page for the sql-code mysql executed in integrate it in your page
Like I told above I don't want that person to have acces to the cpanel.
I want a link on a page (I will password protect it) with something like this:
Download back-up. and if you click on it it will download the .sql file
Like I said: that it should be done with a .PHP file not via phpmyadmin coz that person where I'm making this for has no acces to it.
what do you not understand about this?
I bolded the important things. you should understand what I mean if you read the bold text
the sql changes ever 24 hours so that is not posible. I'm not stupid I know how I can download it...