How do I telnet?

[hardwareirc.com]

Dear all,
I'm trying to import a database via Telnet, after logging in, on the left, instead of:

sql>

I have:

bash-2.04$

What's this?
When I try to follow the instructions in the "moving servers help", I receive errors saying that the instruction isn't recognized. How do I switch to the mysql console? Do I have to connect to another port?

Please help me ASAP

Thanks,
Antonio

[Floris]

Re: How do I telnet?

Originally posted by hardwareirc.com
Dear all,
I'm trying to import a database via Telnet, after logging in, on the left, instead of:

sql>

I have:

bash-2.04$

What's this?
When I try to follow the instructions in the "moving servers help", I receive errors saying that the instruction isn't recognized. How do I switch to the mysql console? Do I have to connect to another port?

Please help me ASAP

Thanks,
Antonio

sql> is the prompt you get after loading mysql

bash$ is the prompt you get, equal to ms-dos's c:\>

From this prompt, you need to start mysql
Find from where it is running and type ni that dir: ./mysql -l login -p databasename

Maybe first try: man mysql
man = manual command
mysql will give mysql command help.
This should give you more details.

[mrbojangle]

Judging by the prompt u put up, they if you want to import a database from a file use the following from the BASE prompt

mysql -uUSERNAME -pPASSWORD database name < sqlfile.sql

to extract a database use the follwowing

mysqldump --opt -uUSERNAME -pPASSWORD database name > sqlfile.sql


hope that helps O_O
which reminds me, i need to back mine up now

[hardwareirc.com]

Thank you, but when I try to execute man sql or man mysql, I receive the message "No manual entry for xxx".

If I execute the command dirs, the only thing that appears is a ~ symbol...

Help!

[Floris]

Originally posted by mrbojangle
Judging by the prompt u put up, they if you want to import a database from a file use the following from the BASE prompt

mysql -uUSERNAME -pPASSWORD database name < sqlfile.sql

to extract a database use the follwowing

mysqldump --opt -uUSERNAME -pPASSWORD database name > sqlfile.sql


hope that helps O_O
which reminds me, i need to back mine up now

Very correct, but please do NOT use password in the prompt, because this is a security breach. Everybody who can do ps aux |grep mysql will see it. (unless the good root has set it to permission denied) Just use -p and it will prompt you for the pass.

Originally posted by hardwareirc.com
Thank you, but when I try to execute man sql or man mysql, I receive the message "No manual entry for xxx".

If I execute the command dirs, the only thing that appears is a ~ symbol...

Help!

You can find mysql with
whereis mysql
with
cd /path/to/mysql
you can change to that dir
if you only get a ~,
then you can see your current dir with pwd command

netblock: ~> man mysql
No manual entry for mysql
netblock: ~> whereis mysql
mysql: /usr/local/mysql
netblock: ~> pwd
/opt/usr/creation
netblock: ~> cd /usr/local/mysql
netblock: /usr/local/mysql> pwd
/usr/local/mysql
netblock: /usr/local/mysql>

Darn, indeed no man for mysql,
It will be in the bin/ dir, so cd to that,
try: ./mysql --help
for desired help

[hardwareirc.com]

Thank you, but nothing to do, if I use the whereis command, I have the message that this command doesn't exist...

But no problem, I simply wanted to import the DB to restore some templates, now I restored them manually.

I have another question:

In the upgrading instructions I read that it's better to "revert" the templates before upgrading... Can I backup only templates? What happens if I don't revert them?

[Steve Machol]

The reason to revert changed templates is to get the full benefit of all bug and security fixes as well as any new feature. You can't make backups of the templates directly. You can however backup the styles that contain these templates by using the Styles download function.

[Floris]

I always make a directory on my hard drive called "vB2.2.(old number).templates" and go to the ACP and modify a template, copy the content, paste in editor and save as templatename_template.txt in that directory.

[hardwareirc.com]

So I can backup templates with the styles backup... great!

But I have another question

When I restore the templates backup after upgrading, I'm sure not to overwrite the updated code?

[Steve Machol]

Why would you restore the templates after upgrading? The upgrade will not affect your customized templates.

[hardwareirc.com]

I need to restore templates because there's the translation in italian!

So when I restore templates I "reset" also the templates update?

[Steve Machol]

As I said you do not need to restore the templates after upgrading. The upgrade process does not overwrite any cusomtized templates. It only overwrites the master set and any templates that haven't been modified.

[hardwareirc.com]

Ok, but if I don't "revert" them before upgrading, don't I risk to upgrade partially the system?

Revertin isn't a vital operation for upgrade?

[Steve Machol]

You don't have to revert the templates prior to upgrading. If you want the full benefit of bug and security fixes, then you should reverting any templates that have changed from your version to the current one. You can do this after upgrading. Then reapply your customizations to them. The changed templates are listed in the individual version announcements in the Annoucements forum. depending of what your current version is, you'll need to read each announcement from the next version to the one for 2.2.6.

[hardwareirc.com]

Ah, ok, understood

Thank you very much,
Antonio