We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
ERROR when import SQL file #1231
ERROR when import SQL file #1231
hi !
after create DB + USER + PASSWORD i try to import mydb.sql from " php admin" and i got this error :
how can i upload mydb.sql without problem ?
thanks,
Tomer
after create DB + USER + PASSWORD i try to import mydb.sql from " php admin" and i got this error :
Code: Select all
Error
SQL query:
/*!40101 SET character_set_client = @saved_cs_client */;
MySQL said: Documentation
#1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
thanks,
Tomer
Re: ERROR when import SQL file #1231
tomer628 wrote:hi !
after create DB + USER + PASSWORD i try to import mydb.sql from " php admin" and i got this error :
how can i upload mydb.sql without problem ?Code: Select all
Error SQL query: /*!40101 SET character_set_client = @saved_cs_client */; MySQL said: Documentation #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'
thanks,
Tomer
Add this to the top of your file remove anything that matches it.
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
Add this to the bottom of your file remove anything that matches it.
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Re: ERROR when import SQL file #1231
YES IT'S WORKING !!!
thanks
thanks
Re: ERROR when import SQL file #1231
this to the top of your file remove anything that matches it.\
________________
== crossword puzzles ==
________________
== crossword puzzles ==