Performance Mnesia vs. MySQL and even row numbers after export/import to MySQL

Oh I'm sorry. I was not writing what I wanted to. The database names did not contain dots. It looked like this:

localhost_ejabberd_jabber-localhost-com

Dots are replaced with dashes.

With phpMyAdmin it is possible to create datebase and user names like this.

$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 88
Server version: 5.0.67-1 (Debian)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE DATABASE localhost_ejabberd_jabber-localhost-com DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-localhost-com DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1

mysql> CREATE DATABASE localhost_ejabberd_jabber_localhost_com DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.02 sec)

mysql> \q
Bye

there is a 64 character limit for database names and a 16 character limit for usernames

=INFO REPORT==== 23-Dec-2008::00:31:47 ===
I(<0.368.0>:ejabberd_listener:119) : (#Port<0.474>) Accepted connection {{127,0,0,1},38521} -> {{127,0,0,1},5222}

=INFO REPORT==== 23-Dec-2008::00:31:48 ===
I(<0.383.0>:ejabberd_c2s:697) : ({socket_state,gen_tcp,#Port<0.474>,<0.382.0>}) Accepted authentication for a234567890b234567890c234567890d234567890

=INFO REPORT==== 23-Dec-2008::00:31:48 ===
I(<0.383.0>:ejabberd_c2s:809) : ({socket_state,gen_tcp,#Port<0.474>,<0.382.0>}) Opened session for a234567890b234567890c234567890d234567890@localhost/Tka

mysql> SELECT * FROM ejadb.users;
+------------------------------------------+----------+
| username | password |
+------------------------------------------+----------+
| a234567890 | aaaaaaaa |
| a2345678901234567890 | aaaaaaaa |
| a234567890b234567890c234567890d234567890 | aaaaaaaa |
| badlop | aaaaeeee |
+------------------------------------------+----------+
4 rows in set (0.00 sec)