Notify me of new posts by email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. Tips, Techniques and Technologies. I needed to transfer about 40 databases from a new clients server over to my hosting platform. In no time I had a 3 line script that was incredibly powerful. I give you backupdbs.
Sign in to comment. You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. This will make restores easier. To backup a single database simply add the db name as a parameter or multiple dbs. Create the user and directories. Remember to make the script executable, and unreadable by others.
Create 'backup' mysql user. Viewed 1k times. Improve this question. Anisa Ibro. Anisa Ibro Anisa Ibro 11 3 3 bronze badges. By "databases", do you mean "schemas"? I need to create a backup of all databases that are in Postgres but on seperate files. In case i have problems with one database I only restore one and not execute all the script — Anisa Ibro.
Add a comment. Active Oldest Votes. Improve this answer. That was very usefull. Great job! Patrick Patrick 1 1 silver badge 5 5 bronze badges. More information about using this utility on Windows can be found here and here An alternative approach to perform a backup is copying the database files, this may be the best solution for large databases, but this is a more complicated way - you can see more details here. Ivan Gusev Ivan Gusev 2 2 silver badges 9 9 bronze badges.
0コメント