Importing database via Xampp Shell - Help
Posted: 14. September 2014 02:00
Can someone tell me how to import a database using the Xampp Shell
I have a 2GB database i want to import. I am trying to do it via the Xampp Shell. But i keep getting these errors depending on which command i put in.
Access is denied
or
Error 1044 <42000>: Access denied for user ''@'localhost'to database 'xentest'
or
Error 1045 <28000>: Access denied for user ''@'localhost' <using password:NO>
Does anyone know exactly the right command for Shell? I've tried 3 things:
C:\xampp\mysql\bin>mysql -u root -p xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
mysql -h localhost -u root xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
C:\xampp\mysql\bin>mysql -u root -p xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
I'm not sure what i'm doing wrong. But i can't import anything.
database name: xentest
username: root
data trying to import: forum_xenforo_13.09.14.sql
I have a 2GB database i want to import. I am trying to do it via the Xampp Shell. But i keep getting these errors depending on which command i put in.
Access is denied
or
Error 1044 <42000>: Access denied for user ''@'localhost'to database 'xentest'
or
Error 1045 <28000>: Access denied for user ''@'localhost' <using password:NO>
Does anyone know exactly the right command for Shell? I've tried 3 things:
C:\xampp\mysql\bin>mysql -u root -p xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
mysql -h localhost -u root xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
C:\xampp\mysql\bin>mysql -u root -p xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
I'm not sure what i'm doing wrong. But i can't import anything.
database name: xentest
username: root
data trying to import: forum_xenforo_13.09.14.sql