Incredinot Posted November 7, 2012 Share Posted November 7, 2012 Hi, We are a webdevelopment business that host alot of individual sites. So what i want to do is update all our databases at once - but how can this be achieved? What i want to do is update xxx in table xxx in all databases. Is this possible? Or do i need to do it one by one? Link to comment https://forums.phpfreaks.com/topic/270413-how-do-i-update-all-databases/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 7, 2012 Share Posted November 7, 2012 You have to execute a query against each table that you want to update. There's no 'all tables' wild-card statement. Link to comment https://forums.phpfreaks.com/topic/270413-how-do-i-update-all-databases/#findComment-1390811 Share on other sites More sharing options...
JonnoTheDev Posted November 7, 2012 Share Posted November 7, 2012 I would write a php script to do this by simply looping over each database. I'm guessing that all the databases are on the same server. If not you will need to grant access from wherever the script runs. Link to comment https://forums.phpfreaks.com/topic/270413-how-do-i-update-all-databases/#findComment-1390873 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.