DBeaver installation guide

A step by step installation guide with screenshot to DBeaver community edition

1. DBeaver Installation Guide By : Amira Elsayed Ismail

2. Agenda DBeaver installation guide

3. What is DBeaver Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

4. 1 Open the DBeaver website. Go to https://dbeaver.io/ in your computer's web browser.

5. 2 Click Download button

6. 3 Choose Windows 64 bit installer

7. 4 You will find the file in your download folder, double click to start installation process

8. 5 Choose the language and press OK

9. 6 Press Next button

10. 7 Click I Agree button

11. 8 Select For anyone who uses this computer and press Next

12. 9 Select DBeaver Community and press Next

13. 10 Press Browse to select where you want program to be installed, or you can leave it as it is

14. 11 Choose the location you want and press OK

15. 12 Make sure your selected location is in the white text box and press Next

16. 13 Press on Install button

17. 14 Wait until the green bar completed and press Next

18. 15 Press on Finish button

19. 16 The installed app will appear in your start menu

20. To start using DBeaver to manage your databases , you have to follow the following steps

21. 17 Navigate to DBeaver installation folder

22. 18 Create new folder and rename it to “MySQL Binaries” inside “DBeaver” folder

23. 19 Navigate to xampp installation folder

24. 20 Open “mysql” folder inside “xampp”

25. 21 Open “bin” folder inside “mysql”

26. 22 Copy the two files “mysql.exe” , “mysqldump.exe”

27. 23 Paste these two files inside “MySQL Binaries” folder that was created before

28. Export and Import DB from DBeaver steps are following

29. 24 Now you can open DBeaver from start menu Make sure that “ XAMPP ” is running and both “ Apache ” and ” MySQL ” are working

30. 25 This is the default view of DBeaver

31. 26 Add new MySQL connection to DBeaver

32. 27 Make sure the setting of your connection as following Host : localhost , Port: 3306 , Username : root , Password : empty These are the default setting of mysql on local machine

33. 28 You will be able to view your databases and the tables inside each database

34. 29 To export database 1- right click on database name and choose tools and then dumb database

35. 30 Make sure all tables inside your database are selected and then press Start

36. 31 Wait until process completed and press OK button

37. 32 You will be able to find the database file inside “DBeaver” installation folder

38. 33 To be able to restore database file 1- open DBeaver and press right click on “Databases” and choose “Create New Database”

39. 34 Enter database name and press OK

40. 35 On the newly created database name , right click and choose tools and the “Restore database”

41. 36 Click on the folder icon to select the file that you want to import

42. 37 Select the file that should be ended with “.sql”

43. 38 Make sure the file name and path are correct and press start

44. 39 Wait until the green bar is completed

45. 40 Here we can see that our database is imported successfully

46. Congratulations You can also easily import database from any file to your DB Management System Your DB Management system is up and running now You can now export and backup your databases and always keep the files save with date to keep database history

47. Get Help http://stackoverflow.com/ https://dbeaver.io/forum/