Importing database via Xampp Shell - Help

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Importing database via Xampp Shell - Help

Postby joey22 » 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
joey22
 
Posts: 2
Joined: 13. September 2014 23:05
Operating System: Windows

Re: Importing database via Xampp Shell - Help

Postby Altrea » 14. September 2014 05:38

We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Importing database via Xampp Shell - Help

Postby joey22 » 14. September 2014 23:31

Thanks! It worked


I ended up using this if anyone needs it too


mysql -h localhost -u root xentest < C:/xampp/htdocs/forum_xenforo_13.09.14.sql
joey22
 
Posts: 2
Joined: 13. September 2014 23:05
Operating System: Windows

Re: Importing database via Xampp Shell - Help

Postby samiulbca@gmail.com » 15. September 2014 03:08

mysql -hlocalhost -uroot -pyourpass < path of mysqldump file
hope it will help
samiulbca@gmail.com
 
Posts: 1
Joined: 15. September 2014 03:04
Operating System: Windows 8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 130 guests