Import data base

[MxSoft]

Hi i uploaded my database to my host in linux, now how do i import it? which is the command?

 

[MiPo91]

You could just import it via phpmyadmin(with browser) if you have installed it on your linux...

 

[MxSoft]

I know but it says that the file is to heavy
Tamaño máximo: 2,048 KB)

 

[MiPo91]

Then do it in parts, like this:
1. Goto your database where you want it to be imported.
2. Then click SQL.
3. Open your old database.sql file with notepad.
4. Then start copy pasting it in parts to the SQL area (remember to click go every time you copy paste new area of the code)

 

[MxSoft]

OMG is a 9 months database, i think there is another way, but i have to edit something in config files

 

[hepo34]

If you have installed both mysql client and server you can import files using the shell. Google for 'import mysql data command line'.

 

[TKO]

or you can open Php.ini and change the max size import sql

 

[Red]

lol. Manual import/export.

mysql -u username -p -h localhost data-base-name < data.sql

example:

mysql -u root -p -h localhost Otserv < Otserv_db.sql

Afterward, you'll be asked for your PMA password, then you should have a long pause and once you see your server name and a line for a new command, it should all be imported.
Red

 

[MxSoft]

Yes ty now is imported , now only have a question, do i have to create a new user to start server? because i only have root account.