RandomLove
Thu 13th May '04, 4:30am
Hi,
I'm trying to import my *.sql file into another server, there are two places where this is mentioned in the documentation. I talking about the compiled help file (vBulletin-3-Manual.chm).
What I usually do is cut & paste the command directly to my linux command prompt then I edit it.
The first place where this mentioned in the chm file is: Appendix 3 -> Moving Servers -> Restoring the Data base on the New Server
mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL
The second place is: Appendix 3 -> Restoring Your MySQL Database Manually -> Via SSH/Telnet
mysql -u dbusername -p databasename < /path/to/backupname.sql
The command in both places look almost identical, but the first place will NOT work using cut & paste. No idea why. Just thought I let you know :)
Cheers
R.L. :)
I'm trying to import my *.sql file into another server, there are two places where this is mentioned in the documentation. I talking about the compiled help file (vBulletin-3-Manual.chm).
What I usually do is cut & paste the command directly to my linux command prompt then I edit it.
The first place where this mentioned in the chm file is: Appendix 3 -> Moving Servers -> Restoring the Data base on the New Server
mysql –uUSERNAME –p NEWDBNAME < /PATH/TO/NEW/DUMP.SQL
The second place is: Appendix 3 -> Restoring Your MySQL Database Manually -> Via SSH/Telnet
mysql -u dbusername -p databasename < /path/to/backupname.sql
The command in both places look almost identical, but the first place will NOT work using cut & paste. No idea why. Just thought I let you know :)
Cheers
R.L. :)