Importing data with mysqldump produces e

Anon

I can dump data from my database into a back up file using "mysqldump"
without problem, but when I try to bring the data back I end up with an
empty database.

This is what I did

MAKE SURE DATABASE "CLIENTS" HAS A TABLE

mysql> show tables;
+------------------+
| Tables in client |
+------------------+
| night |
+------------------+
1 row in set (0.03 sec)

BACKUP DATABASE TO FILE CLIENT.TXT

iceman:~$ mysqldump -uuser -p***** client > client.txt

DROP TABLES FROM DATABASE SO THAT IT IS NOW AN EMPTY DATABASE

mysql> drop table night;
Query OK, 0 rows affected (0.04 sec)

mysql> show tables;
Empty set (0.02 sec)

BRING BACK THE DATA FROM THE BACKUP FILE

iceman:~$ mysqldump -uuser -p***** client < ./client.txt

MySQL dump 7.1

Host: localhost Database: client #-----------------------------------

Server version 3.22.32

CHECK THAT THE DATA WENT INTO THE DATABASE

mysql> use client
Database changed
mysql> show tables;
Empty set (0.04 sec)

RESULT: I STILL HAVE AN EMPTY DATABASE ????????????

I HAVE SEARCHED HIGH AND LOW AND THE SYNTAX SEEMS CORRECT, CAN I
TROUBLE SOMEONE FOR A CLUE ?
I AM ON A SHARED SERVER SO I HAVE NO ACCESS TO MYSQLADMIN

matto

instead of this:

iceman:~$ mysqldump -uuser -p***** client < ./client.txt

I would do it from the mysql shell:

mysql> ./client.txt

this should work.

Anon

Thanks but all I get with that line is
"You have an error in your SQL syntax".

I tried both

mysql> ./client.txt;

and

mysql> client.txt;

Is it the path to that text file I wonder ?