mysql installation is no problem, the problem starts when I enter phpmyadmin and try to upload schema.sql or when installing accmaker I have to enter the path to the config folder
i am using debian 11 VPS
Okay, now I understand your problem. You simply wonder how to import your schema.sql file?
Well,
you don't need to use phpMyAdmin to upload your schema.
You can do all of this via the terminal (CLI - Command Line Interface).
Open a terminal window in the folder where your schema.sql file is located.
First, make sure to login to your MySQL server.
If it's on the same server you're on, type:
If it's on another server, type (change
ip_address to the ip address, and
port_number to the port):
Lua:
mysql -u root -h ip_address -P port_number -p
Once logged in, create a new database and name it whatever you entered in your config file:
Code:
CREATE DATABASE name_of_database;
Then logout from the MySQL database:
Then you can import your schema file into the database by writing:
If it's on the same server you're on, type:
Code:
mysql -u root -p name_of_database < schema.sql
If it's on another server, type (change
ip_address to the ip address, and
port_number to the port):
Code:
mysql -u root -h ip_address -P port_number -p name_of_database < schema.sql
Make sure your terminal window is in the same directory as your schema file. If not, you will have to provide the full path to the schema.sql file. Once you have imported the file like that, you can login to the MySQL database and check that it imported everything:
Code:
mysql -u root -p
SHOW DATABASES;
USE name_of_database;
SHOW TABLES;
SELECT COUNT(*) FROM table_name;