When disabled some how the link in the panel should have been looked at and auto update for the type of guy’s like me
So my domain cp.mydomain.com is pointing to the vps all good i can even see the welcome message if i go without the phpmyadmin.
Success! Your new web server is ready to use.
Managed to connect to a domain added to the server (not the panel one)
ok fair enough, but what when you move a exiting live domain and you don’t want the down time, how do you import the existing database if you can’t connect without the domain pointing to the new install
if is cp.domain.tld added as web domain in admin user, it will work. For migration parts i anyway would do the export and import of mysql dbs over cli using mysql(dump).
Thank you all, this is a big reason why this community is great.
Indeed the above helped me out.
Side note might be good idea to implement the button/link in the control panel for the phpmyadmin to link you to the domain you are in instead to the ip, to avoid confusion, for people like me, lees agile on this
How do i manually import a mysql database with cli command given the fact i have the below details
Mysql database (mariadb) database name is DBCustom and database username is DBCustom and the password is PassordDB and hostname is localhost
reason for this i have 300mb sql that cloudflare will not let me upload trough their cdn so i used this time Navicat for MariaDB to remote do it but be goot to know how can i do it in CLI
Basic admin things: Use scp and real ips for transfer the sql file and mysql with root user, usualy you can run it without any password, its saved in /root/my.cnf
NOTE: Changes have been made on how phpmyadmin/phppgadmin config are included in apache2 config. To restore to the old behaviour add IncludeOptional conf.d/*.inc below IncludeOptional conf.d/*.conf in /etc/apache2/apache2.conf and restart your server.