Grab over 100 mysql colums

SHOW COLUMNS FROM table_name;

for that you need to ensure that the data type specification matches up (i.e. putting a string into a numeric column obviously won’t work out).

if the empty database is supposed to be a clone, you better populate it from an SQL dump.