move table from one schema to another schema ?

Moving tables with space characters in between should be enclosed.

Example:

ALTER TABLE `schema1`.`tbl somename` 
RENAME TO  `schema2`.`tbl somename` ;

If both schema is on same server then Alter table can be used to move tables from one db to another.

alter table old_db.fooTable rename new_db.fooTable